Thanks for all the help! I got it working using the default charset and explicitly setting the necessary columns to UnicodeCol, I am going to try using use_unicode just to verify.
On Mon, Jan 07, 2008 at 03:13:18PM -0500, Glenn MacGregor wrote:Very strange. The offending character can be decoded from latin1 without
> My mistake, not sure what happened, but when I set the charset=latin1 it
> fails in the same place as it fails without the charset set. That is
> cursors.py line 146 which encodes the query using latin1 in both cases,
> means that mysql default charset for the connection is latin1.
>>> unicode("\xc3", "utf-8")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
UnicodeDecodeError: 'utf8' codec can't decode byte 0xc3 in position 0: unexpected end of data
>>> unicode("\xc3", "latin1")