sqlite char, ascii function

Question

Is there any work around in sqlite to cover for the lack of "char()" and "ascii()" function ?

For example:

char(97) => 'a'
ascii('a') => 97

Answer 1

I know this is too late but:

SELECT unicode('a') --ascii('a')
SELECT char(97)     --char(97)

I hope this helps :)

Answer 2

Since the time this question was written, SQLite has evidently added a CHAR() function:

SELECT CHAR(97) -- Result is 'a'

However, the closest I've gotten in the other direction is with the HEX() function:

SELECT HEX('a') -- Result is 61 (hexadecimal, is equal to 97 decimal)

Obtaining a decimal ASCII character value seems like it'd require some convoluted work...