[rt-users] Migration from MySQL to PostreSQL - corrupt characters (german umlaut)

[Maik Nergert]

RT 4.2.8 and MySQL: old and new tickets looks perfectly, also the 
serialized data seems to be ok.


With locale LANG=en_US.UTF-8

^^test ticket with umlaut ü^@^@^@^GSubject


locale LANG=POSIX

^^test ticket with umlaut <C3><BC>^@^@^@^GSubject



Maybe rt-importer or perl opens the binary files with wrong locales and 
while writing to the utf8 Pg DB all characters (<C3><BC>) are being 
re-encoded?


I'm now testing to serialize mysql and import to mysql again.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5413 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150921/e718ba03/attachment.bin>