Home » Windows OSRSS

Problem with Arabic and Persian Characters

Hi everybody

I have a field typed nvarchar() in SQL Server 2008 and it's valued with some characters that contain '?'. But when I search the table with a query with where-clause LIKE '%?%'  or LIKE '%?%' it doesnt return any rows. Even when I copy the exact value from the table to the query, it dos not return any row. There is no problem with varchar datatype. can anybody help me?

 

1 Answer Found

 

Answer 1

If you add N just before the search string such as

SELECT * FROM tbl WHERE col LIKE N'%?%'

 

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter