Search for a string in a CLOB field

[ehsant]

Hi,
I have searched this forum and not found the answer, so I'm asking you guys for help.
The problem is that, I have a database with the NLS_Lang "ar8mswin1256" and which is for Persian / Arabic charactersets.
I want have a table e.g. tblTest with a clob field datatype e.g. fldTest.
I use this query to search in this field :

SELECT * FROM tblTest 
WHERE DBMS_LOB.INSTR(fldTest, 'test', 1, 1) > 0

Evertything works fine and there is no problem and it finds the records containing "test" in it.
But when I want to search for a persian word like :

SELECT * FROM tblTest 
WHERE DBMS_LOB.INSTR(fldTest, '???', 1, 1) > 0

Although there is a record in the table with the word "???" in it, but the query always returns 0 records.

Do you have any clue what should I do?


----
Harsh words break no bones but they do break hearts.
E.T.