UTF-8 encoding error

[pyeguy]

using a sqlite database i have some unicode characters that aren't handled appropriately (windows 10 python 3.5)

OperationalError: (sqlite3.OperationalError) Could not decode to UTF-8 column ....

I get the error using a dict comprehension on a rows object (not using the column with the unicode characters for either the key or value in the dict comp. )

I normally fix this is issue using the built in sqlite3 package using something along the lines of:

con = sqlite3.Conncetion("database.db") con.text_factory = str

anyway to handle this in requests?

[vlcinsky]

Could you provide e.g. dump of such (minimal case) database plus query you are trying to run on it?