arabic query returns empty result

[unpresedented]

I have this query (that runs on Oracle 10g database):

SELECT
 
ge.*, ge.concept AS glossarypivot FROM s_glossary_entries ge WHERE (ge.glossaryid = '161' OR ge.sourceglossaryid = '161') 
 
AND (ge.approved != 0 OR ge.userid = 361) 
 
AND concept = 'م' 
ORDER BY ge.concept 

The query must display all words that begin with the arabic letter "م"
but unfortunately, it returns empty result ..

However, if I run the same query on mysql database, it works well and displays the correct result ..

What should I do in order to get this query working the right way on oracle 10 database?

[magicwand]

what's the characterset of your database ?

select value from from v$nls_parameters where parameter='NLS_CHARACTERSET';

[debasisdas]

I do not understand how your query display all words that begin with the a particular letter.

Which part of your code does that for you ?

[unpresedented]

@magicwand:
I ran the query you've given me, it returned this result: "AL32UTF8"

@debasisdas:
the query works perfectly with english letters only, and the part of the query that exactly filters by english letter 'a' is:

AND concept = 'a'  
 

I hope to get a solution for arabic letters ...

[unpresedented]

if I put a UTF8 character : " ظ… " instead of the arabic character "م" it will work on oracle ...

[amitpatel66]

The condition AND concept = 'م' would no way give you the records that "STARTS" with arabic character even though if your characterset is set perfectly.

You will need to use pattern matching in first case in order to get the desired output.

[unpresedented]

@amitpatel66
yes you are right ...
thank you.