CHAR_LENGTH / CHARACTER_LENGTH - Amazon Kinesis Data Analytics SQL Reference
ExamplesLimitations
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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.