BIT_LENGTH() Function in MySQL

BIT_LENGTH() Function in MySQL

Last Updated : 21 Jun, 2022

BIT_LENGTH() function in MySQL is used to find the length of a given string in bits. The input string can be a character string or number string. Syntax :

BIT_LENGTH(str)

Parameter : Required. str : A string whose bits length to be calculated.

Returns : It returns the length of a given string in bits.
Example-1 : BIT_LENGTH() function to find the bit-length for a character String.

SELECT BIT_LENGTH("geeksforgeeks") AS BitLengthOfString;

Output :

BitLengthOfString
104

Example-2 : BIT_LENGTH() function to find the bit-length for a number String.

SELECT BIT_LENGTH(2020) AS BitLengthOfString;

Output :

BitLengthOfString
32

Example-3 : BIT_LENGTH() function to find the bit-length for every String in a column of a Table.

Table - Student_Details

Student_Id	Student_Name
1	Amit
2	Smriti
3	Virat
4	Rohit
5	Aishwarya

SELECT BIT_LENGTH(Student_Name) AS BitLengthOfName 
FROM Student_Details;

Output :

BitLengthOfName
32
48
40
40
72

BIT_LENGTH() Function in MySQL

J

jana_sayantan

Improve

Article Tags :

Similar Reads

CHAR_LENGTH() Function in MySQL

CHAR_LENGTH() function in MySQL is used to find the length of a given string (in characters). It counts the number of characters and ignore whether the character(s) are single-byte or multi-byte. Syntax : CHAR_LENGTH(str) Parameter : This method accepts one parameter as mentioned above and described

MySQL LENGTH() Function

MySQL LENGTH() function returns the length of a string in bytes. SyntaxThe MySQL LENGTH function syntax is: LENGTH(string) ParametersThe LENGTH function accepts only one parameter. string: A specified string whose length is to be counted.MySQL LENGTH() Function ExamplesLet's look at examples of the

CHARACTER_LENGTH() Function in MySQL

CHARACTER_LENGTH() : This function in MySQL helps to find the length of given string. The length is measured in form of characters. Moreover, CHARACTER_LENGTH() is also the synonym of CHAR_LENGTH() function. Syntax : CHARACTER_LENGTH(string) Parameter : The function accepts only one parameter as fol

LEFT() Function in MySQL

The LEFT() function in MySQL is used to extract a specified number of characters from the left side of a given string. It uses its second argument to decide, how many characters it should return. Syntax: LEFT (str, len)Parameter: This function accepts two parameters as mentioned above and described

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 a