MySQL CHARACTER_LENGTH() Function
The MySQL CHARACTER_LENGTH() function returns the length of the specified string (measured in characters). This function counts a multi-byte character as a single character.
The CHARACTER_LENGTH() function is a synonym for the CHAR_LENGTH() function.
Syntax
CHARACTER_LENGTH(string)
Parameters
string |
Required. Specify the string to return the length for. |
Return Value
Returns the length of the specified string (measured in characters).
Example 1:
The example below shows the usage of CHARACTER_LENGTH() function.
mysql> SELECT CHARACTER_LENGTH('Learning SQL is FUN!'); Result: 20 mysql> SELECT CHARACTER_LENGTH(NULL); Result: NULL mysql> SELECT CHARACTER_LENGTH(''); Result: 0 mysql> SELECT CHARACTER_LENGTH(' '); Result: 1 mysql> SELECT CHARACTER_LENGTH('SQL Tutorial'); Result: 12
Example 2:
Consider a database table called Employee with the following records:
EmpID | Name | City | Age | Salary |
---|---|---|---|---|
1 | John | London | 25 | 3000 |
2 | Marry | New York | 24 | 2750 |
3 | Jo | Paris | 27 | 2800 |
4 | Kim | Amsterdam | 30 | 3100 |
5 | Ramesh | New Delhi | 28 | 3000 |
6 | Huang | Beijing | 28 | 2800 |
The statement given below can be used to get the length of records of City column.
SELECT *, CHARACTER_LENGTH(City) AS CHARACTER_LENGTH_Value FROM Employee;
The query will produce the following result:
EmpID | Name | City | Age | CHARACTER_LENGTH_Value |
---|---|---|---|---|
1 | John | London | 25 | 6 |
2 | Marry | New York | 24 | 8 |
3 | Jo | Paris | 27 | 5 |
4 | Kim | Amsterdam | 30 | 9 |
5 | Ramesh | New Delhi | 28 | 9 |
6 | Huang | Beijing | 28 | 7 |
❮ MySQL Functions