Genshi UnicodeDecodeError while rendering template revisionlog.html for cyrillic revision author name

[aprudnikov]

Error occurred when view revision log.

Genshi UnicodeDecodeError error while rendering template 'D:\python26\lib\site-packages\trac\versioncontrol\templates\revisionlog.html', line 152, char -1

This line is

<td class="author" py:content="authorinfo_short(change.author)" />

And in my SVN repository change.author is cyrillic name Александр. Trac uses MySQL database.

System Information

OS	Windows 7 x64
Python	2.6.5 (r265:79096, Mar 19 2010, 21:48:26) [MSC v.1500 32 bit (Intel)]
Trac	0.12b1
Babel	0.9.5
Genshi	0.6
Subversion	1.6.6 (r40053)
MySQL	server : "5.1.46-community", client: "5.1.33", thread-safe: 1
MySQLdb	1.2.3c1
Mercurial	1.5.1
mod_wsgi	3.0 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})

[Remy Blank]

I cannot reproduce the issue here with SQLite, maybe this is MySQL-specific. Can you confirm that your database is configured with the utf8 character set and and the utf8_bin collation type?

[aprudnikov]

Replying to rblank:

Can you confirm that your database is configured with the utf8 character set and and the utf8_bin collation type?

Yes.

mysql> show create table revision;
...

CREATE TABLE `revision` (
  `repos` int(11) NOT NULL DEFAULT '0',
  `rev` text COLLATE utf8_bin NOT NULL,
  `time` bigint(20) DEFAULT NULL,
  `author` text COLLATE utf8_bin,
  `message` text COLLATE utf8_bin,
  PRIMARY KEY (`repos`,`rev`(20)),
  KEY `revision_repos_time_idx` (`repos`,`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

[aprudnikov]

I run again resync and the error disappeared.

[Remy Blank]

Thanks for he update.