[rt-users] Migration from MySQL to PostgreSQL - Pg datatypes for blobs?

[Emmanuel Lacour]

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.