The CHAR_LENGTH64 function returns
an unsigned 64-bit value containing the character length of the LONG
VARCHAR column or variable parameter, including the trailing
blanks.
Syntax
CHAR_LENGTH64( long-varchar-object )
Parameters
long-varchar-object – the
name of a LONG VARCHAR column in a table or
a LONG VARCHAR variable.
Usage
CHAR_LENGTH64 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_LENGTH64 returns
NULL.