[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