Post reply

arabic data in condition

  • June 11, 2009 at 9:30 am

    #135096

    Dear All,

    i have query with arabic data in condition with two name, so it should return two rows. but it is returning. can u please check the query and let me know what wrong i am doing.

    SELECT * from SubJects Where 1=1 and (PersonName in (N'فيروز خان','خاليد') )

    any help is highly appreciated.

    Thanks

    fairozkhan

  • June 11, 2009 at 9:38 am

    #1008097

    I don't think it is practical to expect Arabic a right to left language without correct data type and collation, check below Micorsoft have covered most you need for Arabic.

    http://msdn.microsoft.com/en-us/library/cc295829.aspx

    Kind regards,
    Gift Peddie

  • June 11, 2009 at 11:24 am

    #1008169

    Hi,

    i got it, the problem was i was adding N only for one name infact it should be added to all the names.

    Thanks All

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply