UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2019' in position 475: ordinal not in range(256)

[anonymous]

[root@ptmon 0.11]# python sqlite2mysql -e /my/path/to/trac -p 'mysql://user:password@localhost/trac' Traceback (most recent call last):

File "sqlite2mysql", line 289, in ?

main(getArgs())

File "sqlite2mysql", line 218, in main

rc = tmigration.migrateTable(tname) or rc

File "sqlite2mysql", line 74, in migrateTable

rc = self.default_copy(table)

File "sqlite2mysql", line 95, in default_copy

mycur.execute(insert_into, row)

File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 158, in execute File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 265, in literal File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 203, in unicode_literal

UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2019' in position 475: ordinal not in range(256)

Using innodb, and I've done: ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Running show create table <table>; on all the tables shows the DEFAULT CHARSET=utf8 and COLLATE=utf8_bin on everything.

Not exactly sure what I'm doing wrong here.