LENGTH function [String]

LENGTH( string-expression )

string-expression The string.

INT

Use this function to determine the length of a string. For example, specify a column name for string-expression to determine the length of values in the column.

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 data type BINARY, the LENGTH function behaves as the BYTE_LENGTH function.

Note

You can use the LENGTH function and the CHAR_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 The LENGTH function is a vendor extension; however, its semantics are identical to those of the CHAR_LENGTH function in the SQL/2008 standard.

The following statement returns the value 9.

SELECT LENGTH( 'chocolate' );

LENGTH function [String]

Syntax

Parameters

Returns

Remarks

Note

See also

Standards and compatibility

Example