Conversion

ENCODE

DuckDB

Mengkonversi binary data (BLOB) ke string menggunakan Base64 encoding.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

ENCODE(blob) | BASE64_ENCODE(blob)

blobBLOBwajib

Binary data yang akan di-encode

SQL

1 SELECT ENCODE('Hello World'::BLOB) AS encoded;

String ke base64.

Hasil

SGVsbG8gV29ybGQ=

SQL

1 SELECT
2   file_name,
3   ENCODE(file_content) AS base64_content
4 FROM files;

Encode file content untuk storage/transfer.

SQL

1 SELECT JSON_OBJECT(
2   'name', 'image.png',
3   'data', ENCODE(binary_data)
4 ) AS file_json
5 FROM uploads;

Binary data dalam JSON format.

SQL

1 SELECT ENCODE(MD5('password')::BLOB) AS encoded_hash;

Encode MD5 hash ke base64.

1	SELECT
2	file_name,
3	ENCODE(file_content) AS base64_content
4	FROM files;