Subject: Upgrading to a Mantis UTF8
Date: 2009/12/05
Author: Alexey Chumakov
Source: http://www.mantisbt.org/wiki/doku.php/mantisbt:upgrade_to_utf8
...
Web resources
Since this procedure still needs to be refined, we wish to collect
here links to other pages with informations and howtos. Feel free to
add your own or comment about the results if you use one of them to
perform the upgrade:
http://www.phpwact.org/php/i18n/charsets - Really useful document on
the issue
Convert a db to UTF8 after upgrading to MySQL 4.1 - 4 steps procedure
http://dev.mysql.com/tech-resources/articles/4.1/unicode.html
http://dev.mysql.com/doc/refman/4.1/en/charset-conversion.html
Turning MySQL data in latin1 to utf-8 - very detailed howto complete
with troubleshooting steps
Perl regexp to test a string for UTF-8 encoding
http://www.herongyang.com/PHP-Chinese
/PHP-MySQL-Character-Set-on-Text-Columns.html
...
Upgrade the mantis database
Upgrade 3 levels according to the book by herongyang about mySQL
and php.
Manage mantis database by issuing following commands in mysql
command line:
mysql -u root -p mantis
...