Conversion

DECODE

DuckDB

Mengkonversi Base64 encoded string kembali ke binary data (BLOB).

Tipe hasil: BLOBDiperbarui: 6 Jan 2026

Syntax

SQL

DECODE(string) | BASE64_DECODE(string)

stringVARCHARwajib

Base64 encoded string

SQL

1 SELECT DECODE('SGVsbG8gV29ybGQ=')::VARCHAR AS decoded;

Base64 ke string.

Hasil

Hello World

SQL

1 SELECT
2   json_data->>'name' AS name,
3   DECODE(json_data->>'data')::VARCHAR AS content
4 FROM api_responses;

Decode base64 dari JSON field.

SQL

1 SELECT
2   original,
3   DECODE(ENCODE(original::BLOB))::VARCHAR = original AS matches
4 FROM test_strings;

Verify encode/decode roundtrip.

SQL

1 SELECT
2   LENGTH(DECODE(base64_data)) AS binary_size,
3   MD5(DECODE(base64_data)) AS content_hash
4 FROM uploaded_files;

Process decoded binary data.

1	SELECT
2	json_data->>'name' AS name,
3	DECODE(json_data->>'data')::VARCHAR AS content
4	FROM api_responses;

1	SELECT
2	original,
3	DECODE(ENCODE(original::BLOB))::VARCHAR = original AS matches
4	FROM test_strings;

1	SELECT
2	LENGTH(DECODE(base64_data)) AS binary_size,
3	MD5(DECODE(base64_data)) AS content_hash
4	FROM uploaded_files;