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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-29 : 09:32:34
|
| Melwin writes "Hi to all, I dont have much indepth knowledge, so please correct me if my approach to solving my problem is not correct. My setup includes an SQL 2000 server and an Oracle 8i database. I have created a linked server in SQL to access data from the oracle database. All's well except for the nls setting (collation in SQL 2000) that is causing some problems for me. My oracle database has arabic data with National character collation set to AR8ISO8859P6. I have an arabic comaptible collation namely SQL_LATIN1_General_CP1256_CI_AS set in SQL 2000. The problem is that when i access the oracle data from SQL, it gives me nothing but '???'. I have only access to the views in Oracle. So is there anything I can do in SQL 2000. If so can any1 give me a link or code which can help me? Also I want to know whether this will work ? thanks in advance " |
|
|
|
|
|
Collation Hassels