I have a SQL Server 2012 DB with a column that includes Arabic text. The column is nvarchar(MAX) with collation Arabic_CI_AI_KS_WS. To test if LIKE searches are working I copied some of the text from the column and pasted it into a query as follows
select * from MyTable where MyColumn like N'%arabic_text%'
I can visually see the text in the column, but the query returns no results. Searching for latin characters in the column works fine.
What else can I try?
Arabic_100_CI_AI_KS_WSinstead as it is newer and more likely to have proper sort weights defined. 2) please post some example strings from your column for us to test with.
COLLATE Arabic_100_CI_AI_KS_WS_SC. Also try: