LENGTH function - Materialize

LENGTH returns the code points in an encoded string.

Signatures

{{% include-syntax file="examples/sql_functions/length" example="syntax" %}}

Parameter	Type	Description
str	`string` or `bytea`	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.

length returns an int.

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

Materialize uses the encoding crate. See the list of supported encodings, as well as their names within the API.
Materialize attempts to convert PostgreSQL-style encoding names into the WHATWG-style encoding names used by the API.

For example, you can refer to iso-8859-5 (WHATWG-style) as ISO_8859_5 (PostrgreSQL-style).

However, there are some differences in the names of the same encodings that we do not convert. For example, the windows-874 encoding is referred to as WIN874 in PostgreSQL; Materialize does not convert these names.

mzsql

SELECT length('你好') AS len;

nofmt

 len
-----
   2

<hr/>

mzsql

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

nofmt

 len
-----
   3