Using Like statement with Persian words

Gullyaner

New Member
I have problem with Persian alphabet in SQL2008 R2 when I'm using Like statement...I can search all worlds ...even '?' and '?' and I have some results but the problem is something like the font used for data inserted...I meant when I enter word '?' like this line below then I have 26 results:\[quote\] Select * from EntityMethod where NamePersian like N'%?%'\[/quote\]And when I enter word '?' like this line below I have 3 results:\[quote\] Select * from EntityMethod where NamePersian like N'%?%'\[/quote\]In fact both '?' and '?' are exactly the same words but just their font is different.The same problem is for '?' like all above...I dun know ,maybe it's not because of their font actuallyI dun know how to solve this problem...thanks anyway
 
Top