How to use the BIT_LENGTH() function in SQL

Overview

The BIT_LENGTH() function calculates and returns the number of bits in a given string.

Syntax

BIT_LENGTH(string) 

Parameter

  • string: This represents the string whose bit length will be returned.

Example

The following code shows how to use the BIT_LENGTH() function in SQL.

CREATE TABLE Product (
id int,
product_name varchar(50),
price varchar(50),
product_id varchar (20)
);
-- Insert data
INSERT INTO Product
VALUES (101,'T-shirt','$100','oo-01-345');
INSERT INTO Product
VALUES (102,'Hand Bag','$65','oo-01-238');
INSERT INTO Product
VALUES (103,'Pen','$2','oo-01-103');
INSERT INTO Product
VALUES (104,'Cereal','$30','oo-01-775');
INSERT INTO Product
VALUES (105,'Wooden spoon','$25','oo-01-788');
INSERT INTO Product
VALUES (106,'cloth clips','$15','oo-01-924');
INSERT INTO Product
VALUES (108,'Zara Perfume','$120','oo-01-245');
-- Query
SELECT product_id,product_name, BIT_LENGTH(product_name) AS btlen_product_name
FROM Product;

Explanation

In the code above:

  • Line 1–7: We create a table called Product with the columns id, product_name, price, and book_id.
  • Line 11–21: We add data into the Book table.
  • Line 24–26: We return the bit length number of the given string product_name column using the BIT_LENGTH() function.

Free Resources