The ASCII function returns the ASCII code value for a character.
ASCII stands for American Standard Code for Information Interchange.
ASCII is a 7-bit character set used as the standard encoding for modern computers.
This example returns the ASCII values for the given characters.
SELECT ASCII('D') AS 'D',
ASCII('p') AS 'p',
ASCII('9') AS '9',
ASCII('½') AS '½',
ASCII('Ø') AS 'Ø'
| D | p | 9 | ½ | Ø |
|---|---|---|---|---|
| 68 | 112 | 57 | 189 | 216 |
Syntax of the ASCII function.
ASCII(character)
