Return the numeric value of the first character. This function returns the code for the leftmost character, supporting multi-byte characters.
ORD(str)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:
If the leftmost character is not a multi-byte character, ORD() returns the same value as the function.
- Return ASCII value of first character
- Create a character from an integer value
This page is licensed: GPLv2, originally from
(1st byte code)
+ (2nd byte code x 256)
+ (3rd byte code x 256 x 256) ...SELECT ORD('2');
+----------+
| ORD('2') |
+----------+
| 50 |
+----------+