# Determining String Length
__*LENGTH function*__
__*CHAR_LENGTH function*__
+ `LENGTH()`: Returns the length of a string in bytes
+ `CHAR_LENGTH()`: Returns the length of a string (in characters)
+ For example:
  + `select length('TiDB 部署中'), char_length('TiDB 部署中');`  
```
tidb> SELECT length('TiDB 部署中'), char_length('TiDB 部署中');
+--------------------------+-------------------------------+
| length('~!@TiDB 部署中@!~')     | char_length('TiDB 部署中')     |
+--------------------------+-------------------------------+
|                       ~!@14@!~ |                             8 |
+--------------------------+-------------------------------+
1 row in set (0.01 sec)
```

------------------------------------------------------------
The default character set is obviously not ASCII:
```
tidb> SELECT length('TiDB 部署中'), char_length('TiDB 部署中'), length(convert('TiDB 部署中' using ascii));
+--------------------------+-------------------------------+-----------------------------------------------+
| length('TiDB 部署中')    | char_length('TiDB 部署中')    | length(convert('TiDB 部署中' using ascii))    |
+--------------------------+-------------------------------+-----------------------------------------------+
| 14                       | 8                             | 23                                            |
+--------------------------+-------------------------------+-----------------------------------------------+
1 row in set (0.00 sec)
```

- LENGTH () return the length of the string in bytes
- CHAR_LENGTH () return the character length of a string