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, 1136🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Start the Command-Line SQL*Plus in Oracle? If you Oracle server or client installed on your w...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...