Red Gate forums :: View topic - Character encoding woes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Character encoding woes

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
lunadesign



Joined: 11 Nov 2011
Posts: 2

PostPosted: Fri Nov 11, 2011 12:31 am    Post subject: Character encoding woes Reply with quote

I'm comparing two SQL Server databases. I've got a varchar field that has extended characters (like the degree symbol) that consistently get messed up by SQL Data Compare (but work fine in SSIS). Is there a setting somewhere that I'm missing?

Thanks in advance!
Back to top
View user's profile Send private message
lunadesign



Joined: 11 Nov 2011
Posts: 2

PostPosted: Fri Nov 11, 2011 4:55 am    Post subject: Reply with quote

I've been doing some digging and discovered one interesting tidbit: the source database uses the SQL_Latin1_General_CP850_BIN2 collation while all of my destination databases use the SQL_Latin1_General_CP1_CI_AS.

So I think the trick is finding some way to get SQL Data Compare or SQL Server to do the code page conversion. Somehow SSIS is doing this without me using any CAST or CONVERT functions. I can't figure out how this with SQL Data Compare.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Fri Nov 11, 2011 3:37 pm    Post subject: Reply with quote

Can you please let us know the situation where the Unicode characters are causing the problem? For instance:
  • The results displayed are not showing the character properly
  • The comparison result is wrong (data should be equal, but DC says it's different)
  • The syncrhonization script does not display properly (in SSMS, Notepad?)
  • The synchronization script will not run on the SQL Server

Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group