sqlite fetchall breacking because decoding.

Fredrik Lundh fredrik at pythonware.com
Wed Jan 9 12:07:37 EST 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

     http://docs.python.org/lib/csv-examples.html#csv-examples

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

</F>




More information about the Python-list mailing list