String

TO_CODE_POINTS

BigQuery

Mengkonversi STRING atau BYTES menjadi array of code points (Unicode untuk STRING, 0-255 untuk BYTES).

Tipe hasil: ARRAY<INT64>Diperbarui: 7 Jan 2026

Syntax

SQL

TO_CODE_POINTS(value)

Parameter

valueSTRING | BYTESwajib

String atau bytes untuk dikonversi

Contoh Penggunaan

String to Code Points

SQL

1 SELECT
2   text,
3   TO_CODE_POINTS(text) as code_points
4 FROM UNNEST(['Hello', '你好']) as text;

Konversi string ke array code points.

Hasil

text	code_points
Hello	[72, 101, 108, 108, 111]
你好	[20320, 22909]

Character Analysis

SQL

1 SELECT
2   code,
3   CHR(code) as char,
4   CASE
5     WHEN code BETWEEN 65 AND 90 THEN 'upper'
6     WHEN code BETWEEN 97 AND 122 THEN 'lower'
7     ELSE 'other'
8   END as type
9 FROM UNNEST(TO_CODE_POINTS('Hello123')) as code;

Analisis per karakter.

Kembali ke BigQuery Functions

1	SELECT
2	text,
3	TO_CODE_POINTS(text) as code_points
4	FROM UNNEST(['Hello', '你好']) as text;

1	SELECT
2	code,
3	CHR(code) as char,
4	CASE
5	WHEN code BETWEEN 65 AND 90 THEN 'upper'
6	WHEN code BETWEEN 97 AND 122 THEN 'lower'
7	ELSE 'other'
8	END as type
9	FROM UNNEST(TO_CODE_POINTS('Hello123')) as code;