CHAR_LENGTH function [String]

CHAR_LENGTH ( string-expression )

string-expression The string whose length is to be calculated.

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.

Note

You can use the CHAR_LENGTH function and the LENGTH function interchangeably for CHAR, VARCHAR, and LONG VARCHAR data types. However, you must use the LENGTH function for BINARY and bit array data types.

SQL/2008 CHAR_LENGTH is a core feature of the SQL/2008 standard. Using CHAR_LENGTH over an expression of type NCHAR comprises part of optional SQL/2008 language feature F421.

The following statement returns the value 8.

SELECT CHAR_LENGTH( 'Chemical' );

CHAR_LENGTH function [String]

Syntax

Parameters

Returns

Remarks

Note

See also

Standards and compatibility

Example