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

2015-10-08 Thread Maik Nergert
I found an older post on the PostgreSQL mailinglist with same problems http://www.postgresql.org/message-id/d960cb61b694cf459dcfb4b0128514c207bb6...@exadv11.host.magwien.gv.at And I was able to fix the issue by dumping and re-importing the db! # Create empty PG-DB rt-setup-database --action c

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

2015-09-29 Thread Maik Nergert
Hi, you are right. History is not affected but Subject, User Real Name, Signature stored in User Preferences, Description of Scrips, Templates, Groups and Queues, Template Content, Article Name I noticed that the problem with the german umlauts is not in all fields. In my history for example

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

2015-09-24 Thread Frank Wissink
I have the same problem. I want to migrate my RT 4.2.12 mysql-database to postgres. Did you find an solution for this problem? I noticed that the problem with the german umlauts is not in all fields. In my history for example the german umlauts displayed correctly but in the ticket subject they di

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

2015-09-21 Thread Maik Nergert
I'm now testing to serialize mysql and import to mysql again. This is working, so it's a problem with Pg smime.p7s Description: S/MIME Cryptographic Signature

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

2015-09-21 Thread 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 ^@^@^@^GSubject Maybe rt-importer or perl opens the binary files with wron

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

2015-09-18 Thread Todd Wade
On 9/17/15 8:12 AM, Maik Nergert wrote: Hexcode from ü → c3 bc is encoded again to → c3 83 (Ã) and c2 bc (¼) (http://www.utf8-zeichentabelle.de/) First I've upgraded RT from 3.8 to 4.2 with mysql db (utf8) and everything went smoothly. Can you confirm that the umlaut can be sucessfully added

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

2015-09-17 Thread Maik Nergert
Hi RT Users, I'm testing the migration from MySQL to PostgreSQL and I'm experiencing problems with LATIN1 characters (particularly German umlauts) after the migration. They look like ü instead ü Hexcode from ü → c3 bc is encoded again to → c3 83 (Ã) and c2 bc (¼) (http://www.utf8-zeichentabe