CHAR_LENGTH function [String]

Function

Returns the number of characters in a string.

Syntax

CHAR_LENGTH ( string-expression )

Parameters

string-expression The string whose length is to be calculated

Usage

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 CHAR_LENGTH value may be less than the BYTE_LENGTH value.

Example

The following statement returns the value 8:

SELECT CHAR_LENGTH( 'Chemical' ) FROM iq_dummy

Standards and compatibility

See also

“BYTE_LENGTH function [String]”