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, 1544🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...