[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