Existe-t-il une fonction dans MySQL pour obtenir le code numérique d'un caractère spécifique ?

ASCII(str)

mysql> SELECT ASCII('A') as 'ASCII VALUE OF CAPITAL A'; +--------------------------+ | ASCII VALUE OF CAPITAL A | +--------------------------+ | 65 | +--------------------------+ 1 row in set (0.00 sec) mysql> SELECT ASCII('a') as 'ASCII VALUE OF CAPITAL a'; +--------------------------+ | ASCII VALUE OF CAPITAL a | +--------------------------+ | 97 | +--------------------------+ 1 row in set (0.00 sec) mysql> SELECT ASCII('Abhay') as 'Left_most Character ASCII value'; +---------------------------------+ | Left_most Character ASCII value | +---------------------------------+ | 65 | +---------------------------------+ 1 row in set (0.00 sec)