MySQL CHAR_LENGTH() Functions – String Functions

by · Published · Updated

MySQL CHAR_LENGTH() Functions: Syntax

CHAR_LENGTH ( string )

MySQL CHAR_LENGTH() Functions: Description

CHAR_LENGTH() functions returns the length of a string (in characters). A multibyte character counts as a single character. This means that for a string containing five 2-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.  See in the examples.

Note : This function is equal to the CHARACTER_LENGTH() function.

MySQL CHAR_LENGTH() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|lef|lef|left”]
Name, Required /Optional, Value Type, Description
string , Required, String , The input string to count the length.
[/table]

MySQL CHAR_LENGTH() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns,
string , returns a string consisting of the characters given by the code values of input integers.
[/table]

MySQL CHAR_LENGTH() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

Related articles : CHAR() , LENGTH().

MySQL CHAR_LENGTH() Functions: Example 1

mysql> SELECT LENGTH(‘tutorialmines’);
+————————-+
| LENGTH(‘tutorialmines’) |
+————————-+
| 13 |
+————————-+
1 row in set (0.00 sec)

mysql> SELECT length(‘§’), char_length(‘§’);
+————–+——————-+
| length(‘§’) | char_length(‘§’) |
+————–+——————-+
| 2 | 1 |
+————–+——————-+
1 row in set (0.00 sec)

mysql> SELECT length(‘€’), char_length(‘€’)
-> ;
+—————+——————–+
| length(‘€’) | char_length(‘€’) |
+—————+——————–+
| 3 | 1 |
+—————+——————–+
1 row in set (0.00 sec)

Below is the mysql terminal screen for above code :

See all MySQL String functions MySQL 8 String Functions.

You may also like...