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, LONG VARCHAR, and NCHAR data types. However, you must use the LENGTH function for BINARY and bit array data types.

This function supports NCHAR inputs and/or outputs.

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