length

Returns the length of an input string value. The length is the number of characters, and UTF-8 characters are counted as a single character.

Syntax

length( <expression> )

Arguments

<expression>

The input expression must be a string value.

Returns

The returned data type is INTEGER.

Examples

VALUES
    (''), ('Joyeux Noël'), ('Merry Christmas'), ('Veselé Vianoce'),
    ('Wesołych Świąt'), ('メリークリスマス'), (NULL),
SELECT $0, length($0);

+------------------+------------+
| $0               | length($0) |
+------------------+------------+
|                  | 0          |
| Joyeux Noël      | 11         |
| Merry Christmas  | 15         |
| Veselé Vianoce   | 14         |
| Wesołych Świąt   | 14         |
| メリークリスマス    | 8          |
| NULL             | NULL       |
+------------------+------------+