OCTET_LENGTH()
functionThe OCTET_LENGTH()
function returns the number of bytes in a given string.
OCTET_LENGTH(string)
string
: This represents the string whose byte length will be returned.The following code shows how to use the OCTET_LENGTH()
function in SQL:
CREATE TABLE Product (id int,product_name varchar(50),price varchar(50),product_id varchar (20));-- Insert dataINSERT INTO ProductVALUES (101,'T-shirt','$100','oo-01-345');INSERT INTO ProductVALUES (102,'Hand Bag','$65','oo-01-238');INSERT INTO ProductVALUES (103,'Ipad','$1200','oo-01-103');INSERT INTO ProductVALUES (104,'Cereal','$30','oo-01-775');INSERT INTO ProductVALUES (105,'Microwave','$520','oo-01-788');INSERT INTO ProductVALUES (106,'cloth clips','$15','oo-01-924');INSERT INTO ProductVALUES (108,'Zara Perfume','$120','oo-01-245');-- QuerySELECT product_id, product_name, OCTET_LENGTH(product_name) AS otlen_nameFROM Product;
Product
that has the id
, product_name
, price
, and book_id
columns.Product
table.product_id
and product_name
columns. We then use the OCTET_LENGTH()
function to return the byte length of each product name in the product_name
column. This is then stored in a new column, otlen_name
.