Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: MSSQL to MySQL via perl

by jfroebe (Parson)
on May 12, 2009 at 14:02 UTC ( #763486=note: print w/ replies, xml ) Need Help??


in reply to MSSQL to MySQL via perl

Hi there,

Microsoft SQL Server and Sybase ASE/IQ/SQL Anywhere will replace unknown characters with a question mark when the default character set does not match the character set of the data being imported.

Recommendation: extract the data out of you MySQL database in a delimited file (csv) using the utf8 (unicode) character set. Import into SQL Server using bcp specifying utf8 with "-Jutf8" parameter and character mode "-c".

Jason L. Froebe

Blog, Tech Blog


Comment on Re: MSSQL to MySQL via perl
Replies are listed 'Best First'.
Re^2: MSSQL to MySQL via perl
by Anonymous Monk on May 12, 2009 at 15:03 UTC

    It appears the OP wants to go MSSQL --> MySQL, not the other way round.

      Somehow I missed that :( The same rules apply: extract out and in with the same character set.

      Jason L. Froebe

      Blog, Tech Blog

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://763486]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (11)
As of 2015-07-28 23:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (260 votes), past polls