Collections:
BIT_LENGTH() - Number of Bits in String
How to count the number of bits of a giving string using the BIT_LENGTH() function?
✍: FYIcenter.com
BIT_LENGTH(string) is a MySQL built-in function that returns the number of Bits of a giving string. For example:
SELECT BIT_LENGTH('O'), BIT_LENGTH('©'), BIT_LENGTH('😋'); -- +-----------------+------------------+--------------------+ -- | BIT_LENGTH('O') | BIT_LENGTH('©') | BIT_LENGTH('😋') | -- +-----------------+------------------+--------------------+ -- | 8 | 16 | 32 | -- +-----------------+------------------+--------------------+
Reference information of the LENGTH() function:
BIT_LENGTH(str): num Returns the length of the string str in bits. Arguments, return value and availability: str: Required. The given string to count the number of bits for. num: Return value. The number of bits in the given string. Available since MySQL 5.7.
Related MySQL functions:
⇒ CHAR() - Building String from Byte Values
⇐ ASCII() - ASCII Value of First Character
2023-11-12, 234🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...