Upgrading to a Mantis UTF8

∟Reference Citations in 2013

∟Upgrading to a Mantis UTF8

'Specifying Character Set for Text Columns' tutorial was cited in the Mantis upgrade guide in 2013.

The Specifying Character Set for Text Columns tutorial was cited in the Mantis upgrade guide in 2013.

Subject: Upgrading to a Mantis UTF8
Date: Jun 10, 2013
Author: Alexey Chumakov
Source: http://www.mantisbt.org/wiki/doku.php/mantisbt:upgrade_to_utf8

Introduction

This HOW TO describes the issues that are involved with upgrading from
1.0.x releases (or ones old than those) to 1.1.0x releases, since in
the 1.1.0x releases Mantis was changed to use UTF8 language files and
encoding for database saved and read from the database. This Wiki
topic is based on an email sent by Alexey Chumakov to the Mantis
mailing lists.

...

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
https://www.herongyang.com/PHP-Chinese
   /PHP-MySQL-Character-Set-on-Text-Columns.html