Syntax for these functions is as follows:
CHAR_LENGTH | CHARACTER_LENGTH ( <character-expression> )
Returns the length in characters of the string passed as the input argument. Returns null if input argument is null.
Expression | Result |
---|---|
CHAR_LENGTH(‘one’) | 3 |
CHAR_LENGTH('') | 0 |
CHARACTER_LENGTH(‘fred’) | 4 |
CHARACTER_LENGTH( cast (null as varchar(16) ) | null |
CHARACTER_LENGTH( cast (‘fred’ as char(16) ) | 16 |
Note: SQLstream streaming SQL does not support the optional USING CHARACTERS | OCTETS clause. This is a departure from the SQL standard.