ORD

Return the numeric value of the first character. This function returns the code for the leftmost character, supporting multi-byte characters.

Syntax

ORD(str)

Description

If the leftmost character of the string str is a multi-byte 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 x 256)
+ (3rd byte code x 256 x 256) ...

If the leftmost character is not a multi-byte character, ORD() returns the same value as the ASCII() function.

Examples

SELECT ORD('2');
+----------+
| ORD('2') |
+----------+
|       50 |
+----------+

See Also

• ASCII() - Return ASCII value of first character

• CHAR() - Create a character from an integer value

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}