MySQL CHAR_LENGTH() Function

The CHAR_LENGTH() function returns the number of characters in a string. This function counts characters, not bytes. It is equivalent to CHARACTER_LENGTH().

MySQL CHAR_LENGTH Function Syntax

CHAR_LENGTH(string);

CHAR_LENGTH(string);

MySQL CHAR_LENGTH Function Example

This query returns the number of characters in the string 'SQL Tutorial'.

SELECT CHAR_LENGTH('SQL Tutorial') AS LengthOfString;

SELECT CHAR_LENGTH('SQL Tutorial') AS LengthOfString;

Note: The CHAR_LENGTH() function is supported in MySQL but not in SQLite. This example does not work in the TechKubo playground.

MySQL CHAR_LENGTH Function Parameters

MySQL CHAR_LENGTH Function Table Column Example

This query returns the number of characters in the first_name column for each patient.

SELECT CHAR_LENGTH(first_name) AS LengthOfName
FROM Patients;

SELECT CHAR_LENGTH(first_name) AS LengthOfName

FROM Patients;

Note: The CHAR_LENGTH() function is supported in MySQL but not in SQLite. This example does not work in the TechKubo playground.

MySQL CHAR_LENGTH Function Notes

• The result is the number of characters, not bytes.
• CHAR_LENGTH() is equivalent to CHARACTER_LENGTH().
• Works in MySQL 4.0 and higher.