w3resource
MYSQL Tutorial

MySQL OCTET_LENGTH() function

OCTET_LENGTH() function

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

Syntax:

OCTET_LENGTH(str)

Argument

Name Description
str A string whose length is to be returned.

The above function is a synonym for LENGTH().

Syntax Diagram:

MySQL OCTET_LENGTH() Function - 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

MySQL String Functions, slide presentation