Member Avatar for IT_Techno

hi

Iam using sql server 2008 r2 with database that saving Arabic and English with it, when i use this sql statement

SELECT * FROM Land_Files WHERE Briefness LIKE '%Qusin%'

it gives me aresult but when i use the same sql Statment with small difference :

SELECT * FROM Land_Files WHERE Briefness LIKE '%قوصين%'

it does not give any result but I am sure i have the word قوصين in Briefness column.

what is the wrong with searching with arabic??

how can i solve this problem ?

Best Thanks

  • 2 Contributors
  • 1 Reply
  • 231 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by LastMitch
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.