char_length

Description

Syntax

‘INT char_length (VARCHAR str)’

Returns the length of the string, and the number of characters returned for multi-byte characters. For example, five two-byte width words return a length of 5, only utf8 encoding is support at the current version. character_length is the alias for this function.

example

1. mysql> select char_length("abc");
2. +--------------------+
3. | char_length('abc') |
4. +--------------------+
5. |                  3 |
6. +--------------------+

8. mysql> select char_length("中国");
9. +------------------- ---+
10. | char_length('中国')   |
11. +-----------------------+
12. |                     2 |
13. +-----------------------+

keyword

CHAR_LENGTH, CHARACTER_LENGTH