LENGTH()

Overview

Count the byte length of a string counting each multi-byte char as multiple bytes unless in ORACLE mode, in which case LENGTH is a synonym for CHAR_LENGTH().

EXAMPLES

SELECT LENGTH('mariadb');
+-------------------+
| LENGTH('mariadb') |
+-------------------+
|                 7 |
+-------------------+
SELECT LENGTH('   ');
+---------------+
| LENGTH('   ') |
+---------------+
|             3 |
+---------------+
SELECT LENGTH(_utf8 x'E28098');
+-------------------------+
| LENGTH(_utf8 x'E28098') |
+-------------------------+
|                       3 |
+-------------------------+
SET sql_mode=CONCAT(@@sql_mode, ',ORACLE');
SELECT LENGTH(_utf8 x'E28098');
+-------------------------+
| LENGTH(_utf8 x'E28098') |
+-------------------------+
|                       1 |
+-------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES