We already look into the perl script to migrate to utf8.
From: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of Vick Khera
Sent: Wednesday, May 20, 2009 4:24 PM
Subject: Re: [Rt-devel] Migrating RT DB from mysql 4.1.11 to 5.0.51
On Tue, May 19, 2009 at 5:40 PM, Arnas.Kupsys@swisscom.com wrote:
Hello we are running RT for our company’s day to day request handling, and customer center issue logging.
We want to migrate RT DB to a new machine (newer OS and new mysql version).
But facing the problems due to the big DB size and table encodings.
We recently upgraded from Postgres 8.0 (or 8.1 I don’t recall which) to 8.3, which had stricted UTF-8 checking, and we had to manually go in and fix up all the UTF-8 errors that were allowed to creep in. It was painful, but scripting it helped a lot…
It sounds really like you have a mysql bug. It seems the correct forum for you is where you filed your bug report.
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel