[pysqlite] more Unicode grief

"Eric S. Johansson" <[email protected]> Sat, 22 Mar 2008 23:45:57 -0400

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

I'm really not sure what to do.  I've installed the latest pysqlite and sqlite, 
verified that the text_factory attribute is Unicode, verify that I am stuffing 
unique code into my records and still, it gives me errors like:

  OperationalError: Could not decode to UTF-8 column 'message_id' with text 
'<20070323191203.4937.qmail@Ð¡²Ì>'

I am puzzled.  The way I read the documentation, I should be getting Unicode 
back all the time from pysqlite.  Why does it appear that pysqlite is trying to 
convert to utf-8?

---eric

-- 
Speech-recognition in use.  It makes mistakes, I correct some.