CHARACTER_LENGTH

Provide the length of the string.

SELECT CHARACTER_LENGTH(“SQL Tutorial”) AS LengthOfString;

Definition and Usage

The CHARACTER_LENGTH() function retrieves the length of a string in characters.

Note: This function is equivalent to the CHAR LENGTH() function.

CHARACTER_LENGTH(string)

Parameter	Description
string	Mandatory. Specifies the string for which the length is counted.

Works in:

From MySQL 4.0

Retrieve the length of the text within the “CustomerName” column.

SELECT CHARACTER_LENGTH(CustomerName) AS LengthOfName
FROM Customers;