NLS_LOWER function v17

NLS_LOWER returns <outputstring> TEXT, with all letters in lowercase.

NLS_LOWER(<inputstring> TEXT [, <'nlsparam'> TEXT])

Where,

inputstring is of the TEXT data type.

nlsparam is of the TEXT data type. You can provide nlsparam in the format 'NLS_SORT=value'. For example 'NLS_SORT=xdanish' where xdanish is treated as the NLS parameter in the NLS config file and according to which the linguistic requirements for case conversion is handled.

The <outputstring> is of the TEXT data type. The return string is in the same character set as inputstring.

Examples

This example shows NLS_LOWER function with default mapping of NLS parameter.

SELECT NLS_LOWER('FASILƏ', 'NLS_SORT = XTURKISH');

 nls_lower 
-----------
 fasilə
(1 row)

This example shows how to add a new mapping of NLS parameter and a collation value in the NLS config file using edb_nls_cf_insert function.

SELECT edb_nls_cf_insert('xturkish', 'pg_catalog.tr-x-icu');

 edb_nls_cf_insert 
-------------------
 
(1 row)

This example shows NLS_LOWER function after adding a new mapping to the NLS config file.

SELECT NLS_LOWER('FASILƏ', 'NLS_SORT = XTURKISH');

 nls_lower 
-----------
 fasılə
(1 row)

This example shows NLS_LOWER function for simple input string.

SELECT NLS_LOWER('AbcDeF pQr', 'NLS_SORT = XAZERBAIJANI');

 nls_lower  
------------
 abcdef pqr
(1 row)