String

CHR

DuckDB

Mengkonversi kode ASCII/Unicode menjadi karakter. Kebalikan dari fungsi ASCII.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

CHR(code)

codeINTEGERwajib

Kode ASCII/Unicode (0-1114111 untuk Unicode)

SQL

1 SELECT
2   code,
3   CHR(code) as character
4 FROM (
5   SELECT unnest([65, 66, 67, 97, 98, 99, 48, 49, 50]) as code
6 );

Mengkonversi kode ASCII ke karakter yang sesuai.

Hasil

SQL

1 SELECT
2   CHR(code) as letter,
3   code
4 FROM (SELECT unnest(range(65, 91)) as code);

Membuat daftar huruf A-Z dari kode ASCII.

Hasil

SQL

1 SELECT
2   'Line1' || CHR(10) || 'Line2' as with_newline,
3   'Tab' || CHR(9) || 'Separated' as with_tab,
4   CHR(169) as copyright_symbol;

Membuat karakter special seperti newline, tab, dan simbol.

Hasil

with_newline	with_tab	copyright_symbol
Line1	Tab Separated	©
Line2

1	SELECT
2	CHR(code) as letter,
3	code
4	FROM (SELECT unnest(range(65, 91)) as code);