Standard SQL - CHAR for ASCII

Question

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

In MySQL, it is easy to use the ascii () function, but SQL-92 does not.

Answer 1

the SQL-92 standard does not mention ASCII at all.

As you say, each RDBMS provider will have its own implementation of how to convert char → ascii and ascii → char.

Most call this feature ASCII().

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

Answer 2

ASCII - 127), SELECT [value] FROM [table] WHERE [character] = 'A' ..