LOWERB

Returns a character string with each ASCII character converted to lowercase. Multi-byte characters are skipped and not converted.

Behavior Type

Immutable

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)