ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

BYTE_LENGTH function [String]

Function 

Returns the number of bytes in a string.

Syntax 

BYTE_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 multi-byte character set, the BYTE_LENGTH value differs from the number of characters returned by CHAR_LENGTH.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

CHAR_LENGTH function [String]

DATALENGTH function [System]

LENGTH function [String]

Example 

The following statement returns the value 12.

SELECT BYTE_LENGTH( 'Test Message' )