The following example illustrates pattern matching in locales. In non-default locales, LIKE and ILIKE perform locale-sensitive string comparisons, including some automatic normalization, using the same algorithm as the "=" operator on VARCHAR types.ĮSCAPE expressions evaluate to exactly one octet-or one UTF-8 character for non-default locales. ILIKE handles language-independent case-folding. In the default locale, LIKE and ILIKE handle UTF-8 character-at-a-time, locale-insensitive comparisons.
0 Comments
Leave a Reply. |