[sqlalchemy] Re: Fwd: [elixir] sqlite3.OperationalError: Could not decode to UTF-8 column

2007-12-05 Thread Michael Bayer
he needs to supply data to the DB as python unicode objects..the strings from the file should be decoded first from ISO-8859. if he wants to sqlite's text_factory feature, he can use a custom connection function described in

[sqlalchemy] Re: Fwd: [elixir] sqlite3.OperationalError: Could not decode to UTF-8 column

2007-12-05 Thread Mitch
On Dec 5, 8:00 am, Michael Bayer [EMAIL PROTECTED] wrote: he needs to supply data to the DB as python unicode objects..the strings from the file should be decoded first from ISO-8859. Thanks for the help. After some experimentation I found that encoding all string data to UTF-8, ignoring