LOWER
Returns a VARCHAR value containing the argument converted to lowercase letters.
LOWER treats the string
argument as a UTF-8 encoded string, rather than depending on the collation setting of the locale (for example, collation=binary) to identify the encoding.
Behavior Type
Syntax
LOWER ( expression )
Parameters
expression |
CHAR or VARCHAR string to convert |
Notes
LOWER is restricted to 32500 octet inputs, since it is possible for the UTF-8 representation of result to double in size.
Examples
=> SELECT LOWER('AbCdEfG'); LOWER --------- abcdefg (1 row)
=> SELECT LOWER('The Bat In The Hat'); LOWER -------------------- the bat in the hat (1 row)
=> SELECT LOWER('ÉTUDIANT'); LOWER ---------- étudiant (1 row)