OperationalError: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='")

[informa@…]

How to Reproduce

While doing a POST operation on /milestone, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'0c63b1499bad6c024ee9ed38',
 'action': u'edit',
 'description': u'\u5728\u5730\U00026ec6\u9769\u5927\u6982\u8981\u68ee',
 'duedate': u'',
 'id': u'',
 'name': u'\u67af\u5728'}

User agent: Mozilla/5.0 (X11; Linux i686; rv:7.0.1) Gecko/20100101 Firefox/7.0.1

System Information

Trac	0.12
Genshi	0.6
mod_python	3.2.8
MySQL	server: "5.0.77", client: "5.0.77", thread-safe: 0
MySQLdb	1.2.1
Python	2.4.3 (#1, Sep 21 2011, 20:06:00) [GCC 4.1.2 20080704 (Red Hat 4.1.2-51)]
setuptools	0.6c11
Subversion	1.6.11 (r934486)
jQuery	1.4.2

Enabled Plugins

SvnAuthzAdminPlugin

0.1.2.-Moved.to.Trac.0.11-

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 513, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 235, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/ticket/roadmap.py", line 591, in process_request
    return self._do_save(req, db, milestone)
  File "/usr/lib/python2.4/site-packages/trac/ticket/roadmap.py", line 648, in _do_save
    new_milestone = Milestone(self.env, new_name, db)
  File "/usr/lib/python2.4/site-packages/trac/ticket/model.py", line 901, in __init__
    self._fetch(name, db)
  File "/usr/lib/python2.4/site-packages/trac/ticket/model.py", line 916, in _fetch
    cursor.execute("""
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='")

[Christian Boos]

Already submitted in #10431.