Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
angelintrouble
Starting Member
1 Post |
 Posted - 2012-04-19 : 11:25:50
|
| 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? |
|
|
RitaBowman
Starting Member
10 Posts |
Posted - 2012-04-24 : 07:07:08
|
| You need to set the result font. Open SSMS and click on Tools|Options. Then click on Environment|Fonts and Colors. Set the Grid Results and Text Results to a unicode font. I use Kalinga which works for the 21 languages I'm currently working with - including Traditional and Simplified Chinese, Japanese, and 7 Indian dialects as well as Spanish, French, English. |
 |
|
|
|
|
|
Chinese characters in SQL Server database