SQL Server2000 does not read arabic

[thehms]

hi all....

i have this SQL database working on sql server 2000 and the database stores arabic data. i connect to it through my site using a DSN. and i am using arabic collation for my database (SQL_LATIN1_GENERAL-CP1256_CI_AS). The problem is that when a user accesses the site it loads the arabic perfectly on it for a little time, after which it becomes question marks (??????? ?????) ...

anyone has any idea how to make the ODBC connection stable with arabic or to connect directly to the databse like a Access db...


Regards,
The HMS

 

[JVZ]

I'm not sure what the problem is...maybe the below site can help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_arabicsupport.asp

Best of luck.