SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Chinese characters in SQL Server database		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

angelintrouble
Starting Member

USA
1 Posts
Posted - 04/19/2012 :  11:25:50  Show Profile  Reply with Quote
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

USA
10 Posts
Posted - 04/24/2012 :  07:07:08  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000