UPPERB
Returns a character string with each ASCII character converted to uppercase. Multibyte characters are not converted and are skipped.
Behavior Type
Syntax
UPPERB ( expression )
Parameters
expression |
(CHAR or VARCHAR) is the string to convert |
Examples
In the following example, the multibyte UTF-8 character é is not converted to uppercase:
=> SELECT UPPERB('étudiant'); UPPERB ---------- éTUDIANT (1 row)
=> SELECT UPPERB('AbCdEfG'); UPPERB --------- ABCDEFG (1 row)
=> SELECT UPPERB('The Vertica Database'); UPPERB ---------------------- THE VERTICA DATABASE (1 row)