id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 10431 "OperationalError: (1267, ""Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"")" admin "==== 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) ` [[br]] `[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 '='"") }}}" defect closed normal general 0.12 normal worksforme