CODEWITHSUNDEEP
sqlsql-server-2008
Fuad
Fuad

Reputation: 231

Using Like statement with Persian words

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:

Select * from EntityMethod where NamePersian like N'%ک%'

And when I enter word 'ك' like this line below I have 3 results:

Select * from EntityMethod where NamePersian like N'%ك%'

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 actually I dun know how to solve this problem...

thanks anyway

Upvotes: 3

Views: 1400

Answers (1)

Fuad
Fuad

Reputation: 231

I found it myself :D...This problem has no solution but converting all database's data (text data) to the same format 'ک' in meeting with this case of both 'ك' and 'ک' together... This problem occurs when Persian letters are in false position and keys on keyboard...also this problem is solvable by adding a component to "system32" folder in windows

Upvotes: 1

Related Questions