How can we help you today? How can we help you today?
lunadesign
Activity overview Badges (0) Posts (1) Comments (1)

Comments

Sort by recent activity
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. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Character encoding woes
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_Ge...
0 votes
Total activity
3
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1