LOWERB
Returns a character string with each ASCII character converted to lowercase. Multi-byte characters are skipped and not converted.
Behavior Type
Syntax
LOWERB ( expression )
Parameters
expression |
CHAR or VARCHAR string to convert |
Examples
In the following example, the multi-byte UTF-8 character É is not converted to lowercase:
=> SELECT LOWERB('ÉTUDIANT'); LOWERB ---------- Étudiant (1 row)
=> SELECT LOWER('ÉTUDIANT'); LOWER ---------- étudiant (1 row)
=> SELECT LOWERB('AbCdEfG'); LOWERB --------- abcdefg (1 row)
=> SELECT LOWERB('The Vertica Database'); LOWERB ---------------------- the vertica database (1 row)