# 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 配備')    |
+-----------------------+----------------------------+
|                    ~!@11@!~ |                          7 |
+-----------------------+----------------------------+
1 row in set (0.00 sec)
```

------------------------------------------------------------
The default character set is obviously not ASCII:
```
tidb> SELECT LENGTH('Deploying TiDB'), CHAR_LENGTH('Deploying TiDB'), LENGTH(CONVERT('Deploying TiDB' using ascii));
+--------------------------+-------------------------------+-----------------------------------------------+
| LENGTH('Deploying TiDB')    | CHAR_LENGTH('Deploying TiDB')    | LENGTH(CONVERT('Deploying 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