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, 228🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...