SQL Select Command with Unicode string does not receive expected data

Question

I am using SQL Server 2008 R2. I want to get a row from a table where the data is not English.

But when I type the command, it doesn't return anything to me.

SELECT * 
FROM PARTY 
WHERE NAME LIKE 'رانا عطا ربانی' 
ORDER BY SRNO

Any suggestions how to get such a record?

+3

Muhammad Shehzad 19 jan. 13 at 6:10 am

1 answer

Mitch wheat · Accepted Answer · 2013-01-19T06:11:19+0000

Have you tried to declare a string literal as unicode?

SELECT * FROM PARTY 
WHERE NAME LIKE N'رانا عطا ربانی' 
ORDER BY SRNO

[This will show you all the columns associated with a row in your database and their mapping: SQL Server 2008 Conflict Conflict .