searching an unicode string (arabic text) in a coloumn

• jaipal vallabhaneni

  SSC Veteran

  Points: 238

  More actions

  September 6, 2010 at 12:54 am

  #141952

  Hi All,

  i have a table where couple of coloumns consititues Arabic text . my requirement is to search for a string in arabic characters on those coloumns , i have been trying run the below query but search query turns out to be not fruitfull.

  SELECT * FROM Coloum1 WHERE (oldarabictext = N'%عملاء%') .

  Can some one help me out with a proper approach for this kind of scenario.

  Regards,

  Jaipal Vallabhaneni

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  September 6, 2010 at 12:56 am

  #1216772

  Try this:

  SELECT * FROM Coloum1 WHERE CHARINDEX( N'?????' , oldarabictext ) > 1

• jaipal vallabhaneni

  SSC Veteran

  Points: 238

  More actions

  September 6, 2010 at 2:50 am

  #1216806

  thank you very much for the response .. i really helped me out...