Re: MySQL ASCII codes

[Frederic Descamps]

Hi Cándido,

The ord() function in MySQL behaves differently regarding your charset (see https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_ord).

But if you want to achieve what you are trying to do, here is one method:

mysql> SELECT ord(CAST('à' AS CHAR CHARACTER SET latin1));
+----------------------------------------------+
| ord(CAST('à' AS CHAR CHARACTER SET latin1)) |
+----------------------------------------------+
| 224 |
+----------------------------------------------+
1 row in set (0.00 sec)

Best regards and thank you for using MySQL!

lefred.