String

CODE_POINTS_TO_STRING

BigQuery

Mengkonversi array of Unicode code points menjadi STRING.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

CODE_POINTS_TO_STRING(code_points)

code_pointsARRAY<INT64>wajib

Array nilai Unicode code point

SQL

1 SELECT
2   CODE_POINTS_TO_STRING([72, 101, 108, 108, 111]) as hello;

Buat STRING dari array code points.

Hasil

Hello

SQL

1 SELECT
2   CODE_POINTS_TO_STRING([128512, 128513, 128514]) as emojis;

Buat string emoji dari code points.

Hasil

😀😁😂

SQL

1 SELECT
2   CODE_POINTS_TO_STRING(
3     ARRAY(SELECT code + 32 FROM UNNEST(TO_CODE_POINTS('HELLO')) as code)
4   ) as lowercase;

Convert uppercase ke lowercase via code points.

Hasil

hello

1	SELECT
2	CODE_POINTS_TO_STRING([72, 101, 108, 108, 111]) as hello;

1	SELECT
2	CODE_POINTS_TO_STRING([128512, 128513, 128514]) as emojis;

1	SELECT
2	CODE_POINTS_TO_STRING(
3	ARRAY(SELECT code + 32 FROM UNNEST(TO_CODE_POINTS('HELLO')) as code)
4	) as lowercase;