On Fri, May 14, 2010 at 11:43:35PM +0200, Václav Ovsík wrote: > Dear Users and Developers, > I'm facing a migration four instances RT 3.2.2 to RT 3.8.8 with a number > of customizations. > Back-end database is MySQL and I have prepared a script for loading > database dumps from old MySQL 3.23.58 to 5.0.51 (Debian Lenny) > and then upgrading RT schema (rt-setup-database). > A next script will migrate from MySQL to PostgreSQL. > The PostgreSQL database cluster is initialized with cs_CZ.UTF-8 locale. > A problem arises with a column Attachments.Content with a pg type text. >
With Pg, this content is handled specifically, see _EncodeLOB in lib/RT/Record.pm. (see also mysql2Pg page on RTwiki). also, are-you sure that you're mysql DB is using utf-8. If not, you should first convert it or convert on the fly in your script. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
