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

user_69358 · Answer

For older versions use cast(X'61' as text) instead of char(97). 61 is the hexadecimal prepresentation of 97.