[Haskell-cafe] How to program with sqlite?
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:
> 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.
thanks for setting me straight. It would be great if you would want to
submit a patch for HDBC-sqlite3 to fix this.
More information about the Haskell-Cafe