Hi,

In my asp.net code, I am trying to retrieve some data from an oracle database using a select statement that includes an arabic string (see in green). The select statement is as follows:

    select * from T_GOG_PHONEBOOK where afl_name like '%عبدالله جابر%' and rownum < 50

For some reason, I don't get any results although, using the same select statement in SQL Navigator, I do get the needed results. The character sets in the database are WE8ISO8859P1 and AL16UTF16 for NLS_CHARACTERSET, and NLS_VCHAR_CHARACTERSET respectively (i cannot change them!).

What could be the reason behind this? Here are some things I tried:

• changing the locale! (I don't know if what I did was right. I think not)
• changing Oracle NLS_Lang in the registry (again, just trial and error)
• encoding the string in my code. ?!?!

 Please help me in this issue. It's been weeks :(

 Regards,