The CHAR_LENGTH function returns a signed 32 bit value containing the character length of the LONG VARCHAR column parameter, including the trailing blanks.
CHAR_LENGTH( long-varchar-column )
long-varchar-column The name of a LONG VARCHAR column.
If the argument is NULL, CHAR_LENGTH returns NULL.
If the character length exceeds 2147483647, an error is returned.