SQL Select Command with Unicode string is not Retrieving the Expected Data

Question

I am using SQL Server 2008 R2. I want the retrieve the row from table in which data is other than than English.

But when I type the command it returns me nothing.

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

Any suggestions, how to retrieve record like that?

Community · Accepted Answer · 2017-05-23 12:12:16Z

6

Have you tried declaring the string literal as unicode?

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

[This will show you all string-related columns in your database, and their collation: Collation conflict SQL Server 2008 ]

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Jan 19, 2013 at 6:11

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Muhammad Shehzad Over a year ago

Thanks Mitch.It gives me the the related record. Is there any solution to retrieve record if i type the first word and it gives me the related records like if i type 'رانا' it will gives all records related to it.

Collectives™ on Stack Overflow

SQL Select Command with Unicode string is not Retrieving the Expected Data

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related