[Haskell-cafe] How to program with sqlite?

Bjorn Bringert bjorn at bringert.net
Tue Mar 25 10:35:23 EDT 2008


On Tue, Mar 25, 2008 at 3:29 PM, Alex Sandro Queiroz e Silva
<asandroq at gmail.com> wrote:
> 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

Hi Alex,

thanks for setting me straight. It would be great if you would want to
submit a patch for HDBC-sqlite3 to fix this.

/Björn


More information about the Haskell-Cafe mailing list