CHAR_LENGTH
Description
Calculates the length of a string. For multi-byte characters, returns the number of characters.
Currently only supports utf8 encoding
Alias
- CHARACTER_LENGTH
Syntax
CHAR_LENGTH ( <str> )Parameters
| Parameter | Description |
|---|---|
<str> | The string to calculate the length of |
Return value
The length of the string
Example
select CHAR_LENGTH("abc"),CHAR_LENGTH("中国")+-------------------------+----------------------------+
| character_length('abc') | character_length('中国') |
+-------------------------+----------------------------+
| 3 | 2 |
+-------------------------+----------------------------+