String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. LENGTH(str)
For a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.
OCTET_LENGTH() is a synonym for LENGTH().

SELECT LENGTH('text');
mysql>