unicode and sql server2000

[adm]

Hello,
I have SQL SERVER 2000 on WINDOWS 2000 ADVANCED SERVER,
there is a problem: I use coldfusion language to add data to SQL 2000 Database> .When I open database for retrieve the data the result as : ??????????????????????????
this is because i use ARABIC LANGUAGE and it is a non UNICODE language .
-I try to set Arabic as default language in my control panel but the problem not solved>>
-I try to insert arabic words in NOISE.DAT file but the as before not changed..

I hope you to advice me and help me to solve the problem

thank you..

jone

 

[tlbroadbent]

How is SQL Server 2000 setup? Which 'Collation Settings' did you select for the Server? Did you choose the general Unicode collation? According to the documentation, it is compatible with the Arabic locale.

Check the following topics in SQL Books Online.

Collation Options for International Support
Using SQL Collations
SQL Server Collation Fundamentals
Collation Settings in Setup
Windows Collation Designators
Collations
Windows Collation Sorting Styles Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin