Oracle String/Char Function - Oracle/PLSQL LENGTHC Function

This Oracle tutorial explains how to use the Oracle/PLSQL LENGTHC function.

The Oracle/PLSQL LENGTHC function returns the length of a Unicode string.

Syntax

The syntax for the Oracle/PLSQL LENGTHC function is:

LENGTHC( string1 )

string1 is the unicode string. string1 can be CHAR, VARCHAR2, NCHAR, or NVARCHAR2.

string1 can not be CLOB or NCLOB.

If string1 is NULL, LENGTHC returns NULL.

Example

LENGTHC(NULL)
-------------
        NULL
 
 LENGTHC('')
-------------
         NULL
 
 LENGTHC(' ')
-------------
           1
 
 LENGTHC('java2s.com')
----------------------
                   9