char_length

char_length

Description

This function returns the length of a string. For multibytes characters, it returns the number of characters. It currently only supports utf8 coding. Note: This function is also named as character_length.

Syntax

INT char_length(VARCHAR str)

Examples

MySQL > select char_length("abc");
+--------------------+
| char_length('abc') |
+--------------------+
|                  3 |
+--------------------+

keyword

CHAR_LENGTH, CHARACTER_LENGTH