String

NORMALIZE_AND_CASEFOLD

BigQuery

Menormalisasi string Unicode dan melakukan case-folding untuk perbandingan case-insensitive yang benar secara Unicode.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

NORMALIZE_AND_CASEFOLD(value [, normalization_mode])

Parameter

valueSTRINGwajib

String yang akan diproses

normalization_modeSTRINGopsional

Mode: NFC, NFD, NFKC (default), NFKD

Default: NFKC

Contoh Penggunaan

Case-insensitive Compare

SQL

1 SELECT
2   NORMALIZE_AND_CASEFOLD('HELLO') = NORMALIZE_AND_CASEFOLD('hello') as equal,
3   NORMALIZE_AND_CASEFOLD('Straße') = NORMALIZE_AND_CASEFOLD('STRASSE') as german;

Perbandingan case-insensitive yang benar.

Hasil

equal	german
true	true

Search Preparation

SQL

1 SELECT
2   name,
3   NORMALIZE_AND_CASEFOLD(name) as search_key
4 FROM `project.dataset.users`
5 WHERE NORMALIZE_AND_CASEFOLD(name) = NORMALIZE_AND_CASEFOLD('José');

Persiapan string untuk pencarian.

Kembali ke BigQuery Functions

1	SELECT
2	NORMALIZE_AND_CASEFOLD('HELLO') = NORMALIZE_AND_CASEFOLD('hello') as equal,
3	NORMALIZE_AND_CASEFOLD('Straße') = NORMALIZE_AND_CASEFOLD('STRASSE') as german;

1	SELECT
2	name,
3	NORMALIZE_AND_CASEFOLD(name) as search_key
4	FROM `project.dataset.users`
5	WHERE NORMALIZE_AND_CASEFOLD(name) = NORMALIZE_AND_CASEFOLD('José');