November 3, 2009 at 12:42 am
Hi all,
We have two databases, both are using different code pages ( 850 & 1250).
we are planing to merge these two codepages.
In this regard Could you please guide me on below mentioned issues?
1. is it possible to merge data from code page 850 into database with code page 1250?
2. Do we have to do any code page conversions before the merge or after the merge?
November 4, 2009 at 3:21 pm
Never done this - but I think you would cast all of your incoming data using the COLLATE operator. Looks like there is plenty of detailed info in BOL or if you Google "SQL COLLATE".
November 5, 2009 at 7:11 am
Also I just became aware of this SSIS component called CodePageConvert that may do you some good....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply