lippo
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER
DB is not created by package. Package only does the "import". Server restarted after changing locale.
to recap, when package is run from your machine, the target is the sql server on the eng win2003 machine?
check your connection string, is[ Auto Translate] set? then turn it off.
When you are running the package from the server its taking the default collation of the server?
ASKER
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.
do you have 2 sql servers or 1?
ASKER
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.
have you checked your connection string for [translation] setting?
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
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
Did you restarted the server after that?