sqlite fetchall breacking because decoding.

Fredrik Lundh fredrik at pythonware.com
Wed Jan 9 18:07:37 CET 2008

tyoc wrote:

>> well, the database *is* corrupt, since sqlite3 (both the engine and the
>> Python binding) expects you to use a supported encoding for the data
>> stored in the database:
>>      http://www.sqlite.org/datatype3.html
>>      http://docs.python.org/lib/node346.html
> Still like I said before, I have imported that data from python source
> was a CVS with that encoding, I readed the lines with module CSV, then
> used insert to the database like:

the CSV module doesn't decode stuff for you; that's up to your code.  see


for sample code (scroll down to the paragraph that starts with "The csv 
module doesn't directly support reading and writing Unicode").


More information about the Python-list mailing list