String

CHR

BigQuery

Mengkonversi nilai Unicode code point menjadi karakter string. Kebalikan dari fungsi ASCII.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

CHR(value)

valueINT64wajib

Unicode code point (0 hingga 0x10FFFF)

SQL

1 SELECT
2   CHR(65) as char_a,
3   CHR(97) as char_lower_a,
4   CHR(9731) as snowman;

Konversi code point ke karakter.

Hasil

char_a	char_lower_a	snowman
A	a	☃

SQL

1 SELECT
2   STRING_AGG(CHR(code), '') as alphabet
3 FROM UNNEST(GENERATE_ARRAY(65, 90)) as code;

Generate string A-Z.

Hasil

ABCDEFGHIJKLMNOPQRSTUVWXYZ

SQL

1 SELECT
2   CONCAT('Line 1', CHR(10), 'Line 2') as with_newline;

Tambahkan newline character.

Hasil

Line 1 Line 2

1	SELECT
2	STRING_AGG(CHR(code), '') as alphabet
3	FROM UNNEST(GENERATE_ARRAY(65, 90)) as code;

1	SELECT
2	CONCAT('Line 1', CHR(10), 'Line 2') as with_newline;