Menu
Amazon Kinesis Data Analytics
SQL Reference

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.

On this page: