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.