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 |
|
srik4u
Starting Member
1 Post |
 Posted - 2007-08-16 : 18:31:34
|
| I am using SQL Server 2000 DTS packages for data extraction and loading. My source is Oracle 9i. In my source oracle tables I have Chinese and Japanese characters.Data type of my source fields is CLOB and my target fields are NTEXT.I was able to use Oracle SQL Developer to view Chinese and Japanese characters in Oracle tables.However, when I try to import this data into SQL Server 2000 I am getting the data in following format:'?????????????????????????????'I would like to know how to extract those fields into SQL Server 2000 using DTS package so that I can view the data in these fields in Japanese and Chinese...Thanks in advanceSrik |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-16 : 18:37:49
|
You have to use UNICODE aware datatypes, and install Chinese/Japanese fonts on your machine for your EM/QA tool.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
How to import Japanese and Chinese characters?