How can we help you today? How can we help you today?

bad synchro : characters messed up

I synchronized one table containing a Text column with the following definition on both servers :

[Text] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL

The target table was empty so I expected them to be equal after the synchro but I found out that SQL Data Compare had changed some characters :

As an example, the source column contains :

"...the consultant<SPAN lang=ZH-CN>’</SPAN>s contract..."

This is changed to :

"...the consultant<SPAN lang=ZH-CN>’</SPAN>s contract..."

SQL Data Compare apparently translates from Unicode to UTF-8. There doesn't seem to be an option to keep the data in Unicode.

I solved the situation by running a simple update statement between the two servers, but that kind of defeats the purpose of SQL Data Compare.

Can you please look into this?

version : 3.3.9.14
Hans Van Eylen
0

Comments

3 comments

Sort by
  • Hans Van Eylen
    I just updated to 3.4.0.8 and still have the same issue.

    Hans
    Hans Van Eylen
    0
  • Brian Donahue
    Hello Hans,

    Sure, but you may want to save the script and run it in Query Analyzer rather than run it directly from the UI.

    If you save the script, you have the option to choose between UTF-8, Unicode, and ASCII.
    Brian Donahue
    0
  • Hans Van Eylen
    Hi Brian,

    thanks ! Works perfectly now.
    Hans Van Eylen
    0

Add comment

Please sign in to leave a comment.