FROM_HEX

1
SELECT
2
  hex_str,
3
  FROM_HEX(hex_str) as binary_data
4
FROM (
5
  SELECT '48656C6C6F' as hex_str UNION ALL -- "Hello"
6
  SELECT '0102030405'
7
);

1
SELECT
2
  original_text,
3
  TO_HEX(ENCODE(original_text)) as hex_encoded,
4
  DECODE(FROM_HEX(TO_HEX(ENCODE(original_text)))) as decoded
5
FROM (SELECT 'DuckDB' as original_text);

1
SELECT
2
  file_name,
3
  FROM_HEX(md5_hex) as md5_binary,
4
  LENGTH(FROM_HEX(md5_hex)) as binary_length
5
FROM (
6
  SELECT 'doc.pdf' as file_name, 'd41d8cd98f00b204e9800998ecf8427e' as md5_hex
7
);