The CHAR_LENGTH function returns
a signed 32-bit value containing the character length of the LONG
VARCHAR column or variable parameter, including the trailing
blanks.
Syntax
CHAR_LENGTH( long-varchar-object )
Parameters
long-varchar-object – the
name of a LONG VARCHAR column or LONG VARCHAR variable.
Usage
CHAR_LENGTH supports LONG
VARCHAR columns and LONG VARCHAR variables
of any size of data. Currently, a SQL variable can hold up to 2GB -
1 in length.
If the argument is NULL, CHAR_LENGTH returns
NULL.
If the character length exceeds 2GB - 1 (2147483647),
an error is returned.