LENGTH(str)

MySQL 8.4

Returns the length of the string str, measured in bytes. A multibyte character counts as multiple bytes. This means that for a string containing five 2-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5. Returns NULL if str is NULL.

Syntax

MYSQL

SELECT LENGTH('text');
4

Examples

Example

The Length() OpenGIS spatial function is named ST_Length() in MySQL.

MYSQL

SELECT LENGTH('text');
4