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 |
|
mgohary
Starting Member
2 Posts |
 Posted - 2007-09-11 : 03:56:17
|
| I want to import data from Oracle Db to SQL Db and I am using openquery to connect to the Oracle linked server, the problem is that there are arabic characters that can't be transferred correctly though both databases have Arabic as their default language.Any suggestions? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 23:52:59
|
| Do you use unicode data type? |
 |
|
|
mgohary
Starting Member
2 Posts |
Posted - 2007-09-13 : 03:46:22
|
| yes I use varchar |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2007-09-19 : 16:43:45
|
| Nvarchar is unicode. |
|
|
|
|
|
|
Importing data from Oracle to SQL