Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Length functionsUse length functions to determine the length of a character column, string, or variable, or of the value returned by a character expression, or (for CHAR_LENGTH in multibyte locales) the number of logical characters.
CHAR_LENGTH FunctionThe CHAR_LENGTH function returns the number of logical characters in its argument, which can be a character column, a character variable, or a quoted string. This built-in function can also be invoked as CHARACTER_LENGTH.

CHAR_LENGTH Function

The CHAR_LENGTH function returns the number of logical characters in its argument, which can be a character column, a character variable, or a quoted string. This built-in function can also be invoked as CHARACTER_LENGTH.

In the default U.S. English locale and other single-byte locales, CHAR_LENGTH behaves exactly like the LENGTH function, and returns the number of bytes in its argument.

For multibyte code sets, however, which various Unicode, East Asian, and other nondefault locales support, the return value can be less than the number of bytes in the argument. For a discussion of this function, see the HCL OneDB™ GLS User's Guide.