What is MySQL OCTET_LENGTH() function?

MySQL OCTET_LENGTH() function is used to count the number of characters in a string. Basically, it is a synonym of LENGTH() function. Its syntax is as follows −

Syntax

OCTET_LENGTH(Str)

Here, Str is a string whose length of characters has to be returned.

Example

mysql> Select OCTET_LENGTH('My name is Ram')As Str_Length;
+------------+
| Str_Length |
+------------+
|         14 |
+------------+
1 row in set (0.00 sec)

Moumita

Published on 20-Feb-2018 10:24:10

• Related Questions & Answers
• What is MySQL ELT() function?
• What is MySQL MAKE_SET() function?
• What is MySQL INTERVAL() function?
• How can I use MySQL OCTET_LENGTH() function to count the number of characters stored in a data column?
• What is the use of MySQL FROM_UNIXTIME() function?
• What is the use of MySQL GET_FORMAT() function?
• What is the use of MySQL LAST_INSERT_ID() function?
• What is the use of MySQL CONCAT_WS() function?
• What is the use of MySQL TRUNCATE() function?
• What is the use of MySQL UNHEX() function?
• What is the use of MySQL SUBSTRING_INDEX() function?
• What is the purpose of MySQL TRIM() function?
• What is the use of MySQL CHAR() function?
• What is MySQL HEX() function and how it is different from CONV() function?
• What is MySQL STRCMP() function and what would be the output of this function?