[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