arabic data in where clause fails........pls help

[Anwar Sayeed]

Hi all,
i am able to save arabic data in to tables of sql server 2000 when I use the
datatype as 'nchar' or 'nvarchar'.

but my problem is I am unable to retrieve this data by querying the table.
if I include any of this arabic words which is present in the table, it is
not retrieving any records.

for eg: in 'emp' table i have made the emp name as nvarchar so that i can
enter arabic name too.
but when search like 'select * from emp where name ='"& arabictext & "'"
it retrievs no records.

could anybody help me urgently.
All helps will be greatly appreciated.

Thanks in advance
Anwar Sayeed

[hosni chaieb]

Assalem,

Try this query instead of yours :

dim sQuery
sQuery = " select * from emp where name like N ' " & arabictext & " ' "

NB : The use of the "N" Predicat forces the search of Unicode (Such Arabic)
strings

Reagrds
Hosni

"Anwar Sayeed" <anwara...@hotmail.com> a écrit dans le message de news:
egssPwz...@TK2MSFTNGP10.phx.gbl...