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 |
|
yipchunyu
Yak Posting Veteran
80 Posts |
 Posted - 2006-12-14 : 21:18:20
|
| I need to import data from Informix DB directly. I installed an ODBC driver on the server and it works.However, when importing data with Chinese characters. It will stored strange characters instead of Chinese.I changed the regional setting of windows 2000 to Traditional Chinese as default. It works then.However, I don't want to do so as it may cause any unknown effect to other application. So, what's the possible better solution for this issue?Many thanks.p.s. I tried to changed the column to Chinese (Windows collation) but it doesn't work. |
|
|
yipchunyu
Yak Posting Veteran
80 Posts |
Posted - 2006-12-14 : 23:01:53
|
| Found a temp solution.I created a new database with Chinese collation.Then use it to import the data from informix and then transfer back to the original DB. It works now. But any better solution? |
 |
|
|
|
|
|
Import Chinese characters from Informix