[storm] storm..SQLite too picky about unicode column contents
Håvard Gulldahl
havard at lurtgjort.no
Fri Aug 31 09:34:34 BST 2007
Thanks for your reply, Gustavo.
On 8/30/07, Gustavo Niemeyer <gustavo at niemeyer.net> wrote:
> > 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?
>
You're quite right, of course. Declaring sqlite columns UNICODE was
something I picked up from another project, quite erroneously, it
seems. *blush*
Well, that's what you get when you think your tools can read your mind...
Thanks for replying to what was really a sqlite, not storm problem!
--
Håvard Gulldahl <havard at gulldahl.no>
More information about the storm
mailing list