length

Description

Syntax

INT length (VARCHAR str)

Returns the length of the string in byte size.

example

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

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

keyword

LENGTH