sqlite utf8 encoding error

Sybren Stuvel sybrenUSE at YOURthirdtower.com.imagination
Thu Nov 17 13:39:02 CET 2005

Greg Miller enlightened us with:
> 'Keinen Text für Übereinstimmungsfehler gefunden'

You posted it as "Keinen Text f<FC>r ...", which is Latin-1, not

> I thought that all strings were stored in unicode in sqlite.

Only if you put them into the DB as such. Make sure you're inserting
UTF-8 text, since the DB won't do character conversion for you.

The problem with the world is stupidity. Not saying there should be a
capital punishment for stupidity, but why don't we just take the
safety labels off of everything and let the problem solve itself? 
                                             Frank Zappa

More information about the Python-list mailing list