CHAR_LENGTH / CHARACTER_LENGTH - Amazon Kinesis Data Analytics SQL Reference
ExamplesLimitations

CHAR_LENGTH / CHARACTER_LENGTH

 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.

Examples

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

Limitations

Amazon Kinesis Data Analytics streaming SQL does not support the optional USING CHARACTERS | OCTETS clause. This is a departure from the SQL:2008 standard.