Conversion

FROM_HEX

DuckDB

Mengkonversi string hexadecimal ke BLOB (binary data). Kebalikan dari TO_HEX.

Tipe hasil: BLOBDiperbarui: 6 Jan 2026

Syntax

SQL

FROM_HEX(hex_string)

Parameter

hex_stringVARCHARwajib

String hexadecimal yang akan dikonversi

Contoh Penggunaan

Konversi Hex ke Binary

SQL

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 );

Mengkonversi hex string ke BLOB.

Hasil

hex_str	binary_data
48656C6C6F	Hello
0102030405	\x0102030405

Round-trip Conversion

SQL

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);

Encode ke hex lalu decode kembali.

Hasil

original_text	hex_encoded	decoded
DuckDB	4475636B4442	DuckDB

Store Binary Hash

SQL

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 );

Menyimpan MD5 hash sebagai binary.

Hasil

file_name	md5_binary	binary_length
doc.pdf	\xd41d8cd98f...	16

Fungsi Terkait

TO_HEXENCODEDECODE

Kembali ke DuckDB Functions

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	);