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-zeichentabelle.de/)First I've upgraded RT from 3.8 to 4.2 with mysql db (utf8) and everything went smoothly.
New server with fresh installed RT, MySQL, Postgresql from package manager System (Debian Jessie) request-tracker: 4.2.8-3+deb8u1 mysql-server: 5.5.44-0+deb8u1 postresql: 9.4.4-0+deb8u1 apache: 2.4.10-10+deb8u3 php: 5.6.13+dfsg-0+deb8u1Now I followed this tutorial to migrate the DB http://requesttracker.wikia.com/wiki/MigrateMysql2PostgresqlV4
The binary files, generated by rt-serializer --clone, include characters like öäü so I suppose that there is something going wrong while importing to Pg.
'rt-setup-database' creates the Pg DB as UTF8. postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+-----------+---------+-------+----------------------- postgres | postgres | SQL_ASCII | C | C | rt4 | rt_user | UTF8 | C | C | template0 | postgres | SQL_ASCII | C | C | =c/postgres +| | | | | postgres=CTc/postgres
template1 | postgres | SQL_ASCII | C | C | =c/postgres +| | | | | postgres=CTc/postgres
postgres=# show server_encoding; server_encoding ----------------- SQL_ASCII (1 row) postgres=# show client_encoding; client_encoding ----------------- UTF8 (1 row) rt4=# select subject from tickets where id=82527; subject ---------------------------------------------------------- Hardware prüfen (1 row)Newly created tickets with umlauts are displayed correctly only the imported are corrupt!
Switching the client_encoding via “set client_encoding='LATIN1';” or directly in /etc/postgresql/9.4/main/postgresql.conf
client_encoding = latin1 #(default would be the database encoding utf8) rt4=# set client_encoding='LATIN1'; SET rt4=# select subject from tickets where id=82527; subject ---------------------------------------------------------- Hardware prüfen (1 row) Can someone help me to migrate the db with a full utf8 setup? Best, Maik
smime.p7s
Description: S/MIME Cryptographic Signature