String

LENGTH

PostgreSQL

Menghitung jumlah karakter dalam string. LENGTH, CHAR_LENGTH, dan CHARACTER_LENGTH adalah fungsi yang sama. Untuk byte length, gunakan OCTET_LENGTH.

Tipe hasil: integer

Syntax

SQL

LENGTH(string)
CHAR_LENGTH(string)
CHARACTER_LENGTH(string)

Parameter

stringtextwajib

String yang akan dihitung panjangnya

Contoh Penggunaan

Panjang String Dasar

SQL

1 SELECT 
2   LENGTH(Hello) AS len1,
3   LENGTH(Hello World) AS len2;

Menghitung jumlah karakter termasuk spasi.

Hasil

len1	len2
5	11

Validasi Input

SQL

1 SELECT 
2   username,
3   LENGTH(username) AS username_length,
4   CASE 
5     WHEN LENGTH(username) < 3 THEN Too Short
6     WHEN LENGTH(username) > 20 THEN Too Long
7     ELSE Valid
8   END AS status
9 FROM users;

Validasi panjang username.

Hasil

username	username_length	status
ab	2	Too Short
john_doe	8	Valid

Unicode Characters

SQL

1 SELECT 
2   LENGTH(日本語) AS char_count,
3   OCTET_LENGTH(日本語) AS byte_count;

LENGTH menghitung karakter, OCTET_LENGTH menghitung byte.

Hasil

char_count	byte_count
3	9

Fungsi Equivalen di Database Lain

LENGTH

MySQL

LENGTH

Snowflake

LENGTH

BigQuery

LENGTH

DuckDB

Fungsi Terkait

CHAR_LENGTH

Kembali ke PostgreSQL Functions

1	SELECT
2	username,
3	LENGTH(username) AS username_length,
4	CASE
5	WHEN LENGTH(username) < 3 THEN Too Short
6	WHEN LENGTH(username) > 20 THEN Too Long
7	ELSE Valid
8	END AS status
9	FROM users;

1	SELECT
2	LENGTH(日本語) AS char_count,
3	OCTET_LENGTH(日本語) AS byte_count;