Arabic SQL query (on Oracle DB) returns empty result

Posted by unprecedented on Stack Overflow See other posts from Stack Overflow or by unprecedented
Published on 2010-06-06T13:10:06Z Indexed on 2010/06/06 13:22 UTC
Read the original article Hit count: 178

Filed under:
|

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 the same database which runs on MYSQL, 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?

P.S. the oracle database character set is : "AL32UTF8"

thank you so much in advance

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle