Error on inserting new ticket using MySQL

[sl-irm@…]

Windows platform

Trac 0.10
Apache 2.0.59
Python 2.4
mod_python 3.2.8
MySQL 4.1.16
MySQL-python binding 1.2.1_p2

Traceback (most recent call last):
  File "D:\Python24\Lib\site-packages\trac\web\main.py", line 356, in dispatch_request
    dispatcher.dispatch(req)
  File "D:\Python24\Lib\site-packages\trac\web\main.py", line 224, in dispatch
    resp = chosen_handler.process_request(req)
  File "D:\Python24\Lib\site-packages\trac\ticket\web_ui.py", line 302, in process_request
    get_reporter_id(req, 'author'))
  File "D:\Python24\Lib\site-packages\trac\ticket\web_ui.py", line 615, in _insert_ticket_data
    for change in self.grouped_changelog_entries(ticket, db):
  File "D:\Python24\Lib\site-packages\trac\ticket\web_ui.py", line 662, in grouped_changelog_entries
    changelog = ticket.get_changelog(when=when, db=db)
  File "D:\Python24\Lib\site-packages\trac\ticket\model.py", line 297, in get_changelog
    "ORDER BY time", (self.id,  str(self.id), self.id))
  File "D:\Python24\Lib\site-packages\trac\db\util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "D:\Python24\Lib\site-packages\trac\db\util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "D:\Python24\Lib\site-packages\MySQLdb\cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "D:\Python24\Lib\site-packages\MySQLdb\connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1267, "Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'UNION'")

[Tim Hatch]

Fixing description, and duplicate of #3182