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.
CHAR_LENGTH64( long-varchar-object )
long-varchar-object The name of a LONG VARCHAR column in a table or a LONG VARCHAR variable.
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.