MySQL OCTET_LENGTH Function

MySQL OCTET_LENGTH function is a synonym of LENGTH function. This MySQL OCTET LENGTH String Function is used to find the length of a user given expression. The syntax of the OCTET_LENGTH of a string in MySQL is as shown below:

SELECT OCTET_LENGTH(String_Expression) FROM Source

MySQL OCTET_LENGTH Example 1

The MySQL String OCTET LENGTH function counts and returns the number of characters inside a given expression. The following query shows multiple ways to use this lOCTET_LENGTH function.

SELECT OCTET_LENGTH('Hello');

SELECT OCTET_LENGTH('Tutorial Gateway');

SELECT OCTET_LENGTH('MySQL Tutorial');
MySQL OCTET_LENGTH Function 1

MySQL OCTET_LENGTH Example 2

Remember, the OCTET_LENGTH String Function counts the empty space as well. Please refer to LENGTH function. Here, we are using this MySQL function on a table. In this example, we are going to find the Octet length of the Department Name column and Email column.

SELECT FirstName,
LastName,
      DepartmentName,
      OCTET_LENGTH(DepartmentName) AS DeptLen,
      Email,
      OCTET_LENGTH(Email) AS EmailLen
FROM `MySQL Tutorial`.employe;
MySQL OCTET_LENGTH Function 2