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 ```

Accepted Answer

I suppose, if you really wanted to, you could create a "ASCII Table" Table of values with a `ASCIICHAR` column, and a `ASCIICODE` column, and populate it with the ASCII table. Then your lookups could be performed in queries / subqueries:

```
SELECT ASCIICHAR FROM ASCIITABLE WHERE ASCIICODE = 97;
```

Really though, Richard J. Ross III's comment is on the money - if you are using SQLite, you are probably accessing it through your calling code, couldn't the computation be done there?

sqlite char, ascii function

Solution

Problem