i can not make query for any information in arabic language

HI,

i work on Sql Developer Edition when i select for any Company name in arabic it does not get any data ,why? although my data are inserted by arabic language,please help me asap,thank you

and my code like this

use today

select CatID from dbo.tbl_Categories
where CatName like '%???????%'

Try to set the default collation to "Arabic_CL_AS"

|||

hi,

please tell me from where can i set that? or if i use specific syntax please send it to me,thank you.

|||try this:

alter table tbl_Categoriesalter column CatNamevarchar(100) COLLATE Arabic_CI_AI

Note the collation provided for this column. Collation is used by SQL Server to store data for different languages. Have a look at COLLATE or COLLATION in BOL. You can use

select *from ::fn_helpcollations()

to check all the installed collations on your server.

Hope this will help.

|||

How to change default collate in SQL
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36707

|||

Hi,

by the way i finished from added may data to database in arabic language i made import from Excel file but the problem is when i make query on arabic data i recieved no row selected how is?,thank you

|||

hi,

i still face the problem, by the way i finished from added my data to database in arabic language i made import from Excel file but the problem is when i make query on arabic data i recieved no row selected how is?,help me,thank you

|||

First of all, you can run the alter table query I provided earlier any time whether your table contains data or not. One more thing is that you can use collation at the time of writing select query too, the syntax is below:

select *from <table name>where <column name>like'<value>' collate Arabic_CI_AI

Now the comparison will be made using the Arabic_CI_AI collate for this select. As I've told earlier there are so many collates to choose from ( even for Arabic ), which differ in some way or another. Choose the collate you want to use and either alter the table permanently or at the time of selecting the values. Just go and have a look at BOL for COLLATE.

Hope this will help

|||

hi,

i altered my table with Arabic_CI_AI after that i write your syntax but still no new :S,thanks

|||

How can I reach all the possible collation options for Arabic?

This is my SQL statement which returns NO VALUES:

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '%?%' COLLATE Arabic_CI_AI)

I also tried

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '%?%' COLLATE Arabic_CL_AS)

as was suggested in one of the forum replies, but it gives an error message saying :
"Invalid Collation" with an error source: " .NetSqlClient Data Provider"

Thanks.