CHAR_LENGTH ( string-expression )

INT

Trailing white space characters are included in the length returned.

The return value of a NULL string is NULL.

If the string is in a multibyte character set, the value returned by the CHAR_LENGTH function may differ from the number of bytes returned by the BYTE_LENGTH function.

• BYTE_LENGTH function [String]
• UltraLite string functions

The following statement returns the value 8.

SELECT CHAR_LENGTH( 'Chemical' );