Encoding Problems (MS SQL -> MySQL)
Posted by:
Pat H
Date: October 30, 2006 11:39AM
Hi,
I want to migrate the data (tables) of a MS SQL (Server 2000) database to MySQL (5.0.23).
For this, i`m using the "MySQL Migration Toolkit" (v. 1.1.4).
My problem is the encoding of the "special characters" like the german umlauts (e.g. ä,ü,ö).
In the target MySQl database (resp. in the the generated script file) the umlauts for "Gemeindebhörden" are displayed as "Gemeindebeh�rden".
The collation of the MS SQL database is Latin1_General_CP1_CI_AS.
In step 3 of the migration (Object Mapping), i tried several charset/collation-settings (e.g. latin1/latin1_german1_ci, latin1/latin1_swedish_ci, utf8/utf8_general_ci).
Does anybody have an idea how to migrate my data with the correct encoding settings ?
Thanks in advance!
P.
Edited 1 time(s). Last edit at 10/30/2006 11:41AM by Pat H.
Subject
Written By
Posted
Encoding Problems (MS SQL -> MySQL)
October 30, 2006 11:39AM
November 03, 2006 10:27AM
December 12, 2006 05:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.