Re: search in arabic



I found the solution its just to put a N before your text which you
searching for

"Select * From arabic Where title like N'%Text%' Order By Title ASC"

Regards

"FaYYaZ" <news@xxxxxxxxxxxxx> wrote in message
news:ed6UDPPQFHA.3296@xxxxxxxxxxxxxxxxxxxxxxx
> Hi every one
>
> I am having problem with search, I have data in sql server in arabic
> language , when I am searching via submitting a form using asp it returns
> me
> nothing and select statment looks like this "Select * From arabic Where
> title like '%Ù.%' Order By Title ASC" search text "'Ù.%' " is not what
> I
> typed to search.
>
> But when I type manually in query analyzer like "Select * From arabic
> Where
> title like '%arabic text%' Order By Title ASC" it works.
>
> Please advise me where I am going wrong.
>
> Regards
>
>
>
>
>


.



Relevant Pages

  • Re: Controlling/Replacing Avaiable Styles
    ... > Easier would be to do find-replace for each style, searching the entire ... > Jonathan West - Word MVP ...
    (microsoft.public.word.vba.beginners)
  • usb over ip
    ... Searching I found that the subject is very close to what I want: ... Regards, ... > Impossible for most buses. ... > emulator) which will require the second PC to execute. ...
    (microsoft.public.development.device.drivers)
  • Working several docs at the same time with Word 2000
    ... I have a question with regards to working with several documents ... any noticable loss of resources, in particular when printing. ... I can not find any setting within Word options, and searching on the web ...
    (microsoft.public.word.docmanagement)
  • Working several docs at the same time with Word 2000
    ... I have a question with regards to working with several documents ... any noticable loss of resources, in particular when printing. ... I can not find any setting within Word options, and searching on the web ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Thumbnails in dvr-ms not working: help please
    ... J-Clydebank wrote: ... Have done some other searching and it seams the following file is suppose to be used MediaMetadataHandler.dll ... Most threads seams to have the problem where nero has been installed, this is not the case with myself, clean install of vista home premium on a hp media centre tv m7670 ...
    (microsoft.public.windows.mediacenter)