String

ASCII

BigQuery

Mengembalikan nilai ASCII (code point) dari karakter pertama dalam string.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

ASCII(value)

Parameter

valueSTRINGwajib

String input (hanya karakter pertama yang diproses)

Contoh Penggunaan

Get ASCII Value

SQL

1 SELECT
2   ASCII('A') as upper_a,
3   ASCII('a') as lower_a,
4   ASCII('0') as zero;

Dapatkan nilai ASCII dari karakter.

Hasil

upper_a	lower_a	zero
65	97	48

Check Character Type

SQL

1 SELECT
2   char,
3   ASCII(char) as code,
4   CASE
5     WHEN ASCII(char) BETWEEN 65 AND 90 THEN 'uppercase'
6     WHEN ASCII(char) BETWEEN 97 AND 122 THEN 'lowercase'
7     WHEN ASCII(char) BETWEEN 48 AND 57 THEN 'digit'
8     ELSE 'other'
9   END as char_type
10 FROM UNNEST(['A', 'z', '5', '@']) as char;

Klasifikasi karakter berdasarkan ASCII.

Fungsi Terkait

REVERSEREPEATTRANSLATECHR

Kembali ke BigQuery Functions

1	SELECT
2	ASCII('A') as upper_a,
3	ASCII('a') as lower_a,
4	ASCII('0') as zero;

1	SELECT
2	char,
3	ASCII(char) as code,
4	CASE
5	WHEN ASCII(char) BETWEEN 65 AND 90 THEN 'uppercase'
6	WHEN ASCII(char) BETWEEN 97 AND 122 THEN 'lowercase'
7	WHEN ASCII(char) BETWEEN 48 AND 57 THEN 'digit'
8	ELSE 'other'
9	END as char_type
10	FROM UNNEST(['A', 'z', '5', '@']) as char;