LENGTH function [String]

Returns the number of characters in the specified string.

LENGTH ( string-expression )

The following statement returns the value 9:

SELECT LENGTH( 'chocolate' ) FROM iq_dummy

If the string contains multibyte characters, and the proper collation is being used, LENGTH returns the number of characters, not the number of bytes. If the string is of BINARY data type, the LENGTH function behaves as BYTE_LENGTH.

The LENGTH function is the same as the CHAR_LENGTH function.