Standard SQL - CHAR to ASCII

Question

Using standard SQL, SQL-92, how can I convert a character to an ASCII value?

In MySQL it's easy using the ascii() function, but SQL-92 doesn't have this.

Answer 1

It appears the SQL-92 standard doesn't even mention ASCII at all.

As you say, each RDBMS vendor would have its own implementation how to convert char->ascii and ascii->char.

Most name this function ASCII().

• SQL Server ASCII
• Postgresql ASCII
• Oracle ASCII
• MySQL ASCII