April 19, 2012 at 9:11 am
I needed to move some data containing chinese alphabets in Oracle Database to SQL Server Database. I saved the data from Oracle as a dat file say x.dat. I am using x.dat as my source file and using file connection manager in SSIS. I am trying to transfer the data to the corresponding table in SQL Server. Oracle table and SQL Server table have the same structure. Data type in Oracle is varchar(50) and the corresponding columns in SQL Server has data type nvarchar(255). I changed the codepage option in file manager in SSIS to Traditional Chienese. The data is loaded. How should I know the Chinese letters are moved correctly? If I use select statement in Oracle the Chinese letters are displayed as ' ??? ' not in the form of a chinese letter. After moving data to SQL Server I used select statement in SQL Server . The characters are displayed as some kind of rectangles or boxes . Is there any way to see the characters as real Chinese characters? Is there any way to make sure the data is transferred correctly?
If I use code page as Korean or Tamil or Telgu it will allow all records to insert in SQL Server. Does it mean the Chinese letters are converted to Korean or Tamil or Telgu?
Is there any other way to do that?
April 19, 2012 at 9:40 am
If chinese characters are stored properly in SQL Server then they will display properly in Management Studio. So I would work on the assumption they have been mangled somewhere.
I would start by checking if they are right in Oracke - it sounds odd that they do not get displayed properly there.
Mike
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply