[storm] storm..SQLite too picky about unicode column contents
Gustavo Niemeyer
gustavo at niemeyer.net
Thu Aug 30 14:06:50 BST 2007
Hi Håvard,
> First off, thanks for storm.
You're welcome! :-)
> Then, to something that confuses me wildly. I have a table where some
> columns are sometimes strings and sometimes ints, so I've declared
> them as UNICODE in my CREATE TABLE sql.
"UNICODE" has no meaning for sqlite, and ends up being handled as a number.
Can you please try to use "TEXT" instead?
To understand why, please checkout the section "2.1 Determination Of Column
Affinity" in the following sqlite document:
http://www.sqlite.org/datatype3.html
--
Gustavo Niemeyer
http://niemeyer.net
More information about the storm
mailing list