[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

import fields with chinese text from Oracle to MSSQL

I have a table from Oracle with some fields containing Chinese Characters.  I created a DTS package in MSSQL 2000 server (English Win2000) with transformation of that table from Oracle to MSSQL.  The chinese text field on the MSSQL side are ntext.   If I run the package on my PC (Chinese Win2000), the import is ok.  But if I run the package directly on the testing server (English Win2000), the chinese text imported to MSSQL became unknown characters.  Please help.  Urgent!

Note: I tried to change locale of the testing server to Chinese Traditional and also checked the box of supporting Chinese Traditional characters under Control Panel/Regional Setting.  Doesn't work.
0
lippo
Asked:
lippo
  • 6
  • 3
  • 2
  • +1
1 Solution
 
imitchieCommented:
on the test ms sql server (eng win 2000), create the database with default collation of one of the CHINESE collations, i.e. 197 before transfer
check http://msdn2.microsoft.com/en-us/library/aa176552(SQL.80).aspx
0
 
imran_fastCommented:
>>I tried to change locale of the testing server to Chinese Traditional and also checked the box of supporting Chinese Traditional characters under Control Panel/Regional Setting.  Doesn't work.

Did you restarted the server after that?
0
 
imitchieCommented:
if your package is creating the db, it may be inheriting it from the local system's regional settings (which changes between the two servers). try creating the db first
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
lippoAuthor Commented:
DB is not created by package. Package only does the "import".  Server restarted after changing locale.
0
 
imitchieCommented:
to recap, when package is run from your machine, the target is the sql server on the eng win2003 machine?
0
 
imitchieCommented:
check your connection string, is[ Auto Translate] set? then turn it off.
0
 
imran_fastCommented:
When you are running the package from the server its taking the default collation of  the server?
0
 
lippoAuthor Commented:
is collation matter? I thought it is only related to sorting but not encoding.  I am not sure what you are asking, but my tables uses default collation of the database.

0
 
imitchieCommented:
do you have 2 sql servers or 1?
0
 
lippoAuthor Commented:
1 server.  The package and  the table belto ongs the  server. Enterprise Manager is installed on my PC(Chinese Win2000) to access the server's database to run the package.  If I run the package directly on the server (English Win2000), chinese text turned monsters.
0
 
imitchieCommented:
have you checked your connection string for [translation] setting?
0
 
DavidSenior Oracle Database AdministratorCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
 
I will leave the following recommendation for this question in the Cleanup Zone:
Award points to imitchie {20318245}

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

dvz
Oracle Community Volunteer
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 6
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now