Collections:
ASCII() - ASCII Value of First Character
How to get the ASCII value of the first character of the a given string using the ASCII() function?
✍: FYIcenter.com
ASCII(string) is a MySQL built-in function that returns the ASCII value of the first character of a giving string. For example:
SELECT ASCII('dba.FYIcenter.com'); -- +----------------------------+ -- | ASCII('dba.FYIcenter.com') | -- +----------------------------+ -- | 100 | -- +----------------------------+ SELECT ASCII('O'), ASCII('©'), ASCII('😋'); -- +------------+-------------+---------------+ -- | ASCII('O') | ASCII('©') | ASCII('😋') | -- +------------+-------------+---------------+ -- | 79 | 194 | 240 | -- +------------+-------------+---------------+ SELECT HEX('O'), HEX('©'), HEX('😋'); -- +----------+-----------+-------------+ -- | HEX('O') | HEX('©') | HEX('😋') | -- +----------+-----------+-------------+ -- | 4F | C2A9 | F09F988B | -- +----------+-----------+-------------+
Reference information of the ASCII() function:
ASCII(str): num Returns the numeric value of the leftmost character of the string str. Returns 0 if str is the empty string. Returns NULL if str is NULL. ASCII() works for 8-bit characters. Arguments, return value and availability: str: Required. The given string to return the ASCII value of the first characters for. num: Return value. The ASCII value of the first character. Available since MySQL 4.0.
Related MySQL functions:
⇒ BIT_LENGTH() - Number of Bits in String
⇐ MySQL Functions on Character String Values
2023-11-11, 227🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...