Collections:
ORD() - Order Value of First Character
How to calculate the order value of the first character in a string using the ORD() functions?
✍: FYIcenter.com
ORD(str, pos, len) is a MySQL built-in function that order value of the first character of a giving string. For example:
SELECT ORD("dba.FYIcenter.com"); -- +--------------------------+ -- | ORD("dba.FYIcenter.com") | -- +--------------------------+ -- | 100 | -- +--------------------------+ SELECT ORD('O'), ORD('©'), ORD('😋'); -- +----------+-----------+-------------+ -- | ORD('O') | ORD('©') | ORD('😋') | -- +----------+-----------+-------------+ -- | 79 | 49833 | 240 | -- +----------+-----------+-------------+ SELECT HEX('O'), HEX('©'), HEX('😋'); -- +----------+-----------+-------------+ -- | HEX('O') | HEX('©') | HEX('😋') | -- +----------+-----------+-------------+ -- | 4F | C2A9 | F09F988B | -- +----------+-----------+-------------+
Reference information of the ORD() function:
ORD(str): int If the leftmost character of the string str is a multibyte character, returns the code for that character, calculated from the numeric values of its constituent bytes using this formula: (1st byte code) + (2nd byte code * 256) + (3rd byte code * 256^2) ... If the leftmost character is not a multibyte character, ORD() returns the same value as the ASCII() function. Arguments, return value and availability: str: Required. The given string to be calculated on int: Return value. The order value of the first character. Available since MySQL 5.7.
Related MySQL functions:
⇒ POSITION() - Synonym for LOCATE()
⇐ OCTET_LENGTH() - Synonym for LENGTH()
2023-11-13, 233🔥, 0💬
Popular Posts:
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...