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: 213
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