String

ASCII

DuckDB

Mengembalikan kode ASCII dari karakter pertama dalam string. Berguna untuk character encoding dan sorting logic.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

ASCII(string)

Parameter

stringVARCHARwajib

String yang karakter pertamanya akan diambil kode ASCII-nya

Contoh Penggunaan

Mendapatkan Kode ASCII

SQL

1 SELECT
2   char_val,
3   ASCII(char_val) as ascii_code
4 FROM (
5   SELECT 'A' as char_val UNION ALL
6   SELECT 'a' UNION ALL
7   SELECT 'Z' UNION ALL
8   SELECT '0' UNION ALL
9   SELECT '@'
10 );

Melihat kode ASCII dari berbagai karakter.

Hasil

char_val	ascii_code
A	65
a	97
Z	90
0	48
... 1 baris lainnya

Cek Karakter Adalah Huruf

SQL

1 SELECT
2   name,
3   LEFT(name, 1) as first_char,
4   CASE
5     WHEN ASCII(UPPER(LEFT(name, 1))) BETWEEN 65 AND 90 THEN 'Letter'
6     WHEN ASCII(LEFT(name, 1)) BETWEEN 48 AND 57 THEN 'Number'
7     ELSE 'Other'
8   END as char_type
9 FROM products;

Mengkategorikan karakter pertama nama produk.

Hasil

name	first_char	char_type
Apple	A	Letter
123Phone	1	Number
@Special	@	Other

Custom Sorting by ASCII

SQL

1 SELECT name
2 FROM items
3 ORDER BY
4   CASE WHEN ASCII(name) BETWEEN 48 AND 57 THEN 1 ELSE 0 END,
5   name;

Sorting dengan huruf lebih dulu, lalu angka.

Hasil

name
Alpha
Beta
Gamma
123Item
... 1 baris lainnya

Fungsi Terkait

REVERSEREPEATCHR

Kembali ke DuckDB Functions

1	SELECT
2	char_val,
3	ASCII(char_val) as ascii_code
4	FROM (
5	SELECT 'A' as char_val UNION ALL
6	SELECT 'a' UNION ALL
7	SELECT 'Z' UNION ALL
8	SELECT '0' UNION ALL
9	SELECT '@'
10	);

1	SELECT
2	name,
3	LEFT(name, 1) as first_char,
4	CASE
5	WHEN ASCII(UPPER(LEFT(name, 1))) BETWEEN 65 AND 90 THEN 'Letter'
6	WHEN ASCII(LEFT(name, 1)) BETWEEN 48 AND 57 THEN 'Number'
7	ELSE 'Other'
8	END as char_type
9	FROM products;

1	SELECT name
2	FROM items
3	ORDER BY
4	CASE WHEN ASCII(name) BETWEEN 48 AND 57 THEN 1 ELSE 0 END,
5	name;