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, 1086🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...