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, 234🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...