MySQL OCTET_LENGTH() function

OCTET_LENGTH() function

MySQL OCTET_LENGTH() returns the length (in characters) of a string.

Syntax:

OCTET_LENGTH(str)

Argument:

The above function is a synonym for LENGTH().

Syntax Diagram:

MySQL Version: 5.6

Video Presentation:

Example: MySQL OCTET_LENGTH() function

The following MySQL statement will return the length of the string w3resource. The return value is 10.

Code:

SELECT OCTET_LENGTH("w3resource");

Sample Output:

mysql> SELECT OCTET_LENGTH("w3resource");
+----------------------------+
| OCTET_LENGTH("w3resource") |
+----------------------------+
|                         10 | 
+----------------------------+
1 row in set (0.00 sec)

All String Functions

Previous: NOT REGEXP
Next: ORD