Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

sql

How to use the BIT_LENGTH() function in SQL

Maria Elijah

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.

RELATED TAGS

sql
RELATED COURSES

View all Courses

Keep Exploring