OCTET_LENGTH() Function in MySQL
In this article, we are going to cover the OCTET_LENGTH function. And will see syntax and example of OCTET_LENGTH function. Let’s discuss one by one.
OCTET_LENGTH function in MySQL is used to returns the number of characters in a given string.
Syntax :
OCTET_LENGTH( str )
Parameter :
This function accepts one parameter as mentioned above in the syntax and described below in the example.
- str : Given string whose number of characters is to be find.
Returns –
It returns the length of given string.
Example-1 :
Applying OCTET_LENGTH() Function to a string.
SELECT OCTET_LENGTH('geeksforgeeks')
as String_Length;
Output :
Example-2 :
Applying OCTET_LENGTH() Function to a number string.
SELECT OCTET_LENGTH(56432)
as Length;
Output :
Example-3 :
Applying OCTET_LENGTH() Function to a column in a table.
Table – Student_Details
Student_Id | Student_Name |
134500 |
Amit Singh |
134501 |
Arunima Rao |
134502 |
Shreya Sharma |
134503 |
Leena Mondal |
Finding total length of name of every student(includes one space).
SELECT OCTET_LENGTH(Student_Name) as Name_Length
FROM Student_Details ;
Output :
Last Updated :
24 Sep, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...