[Haskell-cafe] How to program with sqlite?

Alex Sandro Queiroz e Silva asandroq at gmail.com
Tue Mar 25 10:29:49 EDT 2008


Hallo,

Bjorn Bringert wrote:
> 
> This is SQLite's fault. In SQLite, all types are aliases for STRING.
> Whatever type you use in the create and insert, you will get strings
> back.
> 

      That's not true. SQLite has integers (64 bits) and reals. But, if 
you try to read the field as text it will gladly convert it for you. For 
          reading as the correcting type, the binding should have used 
sqlite3_column_get_type first.

Cheers,
-alex



More information about the Haskell-Cafe mailing list