LENGTH Function

LENGTH returns the graphemes (which is roughly equivalent to printed characters) in a string.

Signatures 

length ( str , encoding_name )
Parameter Type Description
str string The string whose length you want.
encoding_name string The encoding you want to use for calculating the string’s length. Defaults to UTF-8.

Return value 

length returns an Int.

Details 

Errors 

length operations might return NULL values indicating errors in the following cases:

Fixed-width strings 

Materialize returns the length of fixed-width strings as the maximum width of the string. For example length on a CHAR(15) column returns 15 as each string’s length.

Materialize receives strings from your database in the same format they are emitted. In the case of fixed-width strings, e.g. CHAR columns in PostgreSQL, we receive the value padded by empty spaces. Because we cannot determine whether those spaces were intentional or an artifact of a fixed-width string, we provide the length of the string as we received it.

You can find any updates on this behavior in this GitHub issue.

Encoding details 

Examples 

SELECT length('你好') AS len;
 len
-----
   2

SELECT length('你好', 'big5') AS len;
 len
-----
   3