MySQL Forums
Forum List  »  Connector/JDBC and Java

Query Arabic text.
Posted by: Ahmad Sakhi
Date: December 06, 2016 09:38AM

Hello all,

I have a J2EE application, and I am connecting to my backend MySLQ DB, to query a table that has Arabic texts stored. The Arabic text is stored properly in my DB, and I can retrieve and display it alright.

The problem is when I use an Arabic text to compare it in a SELECT query. i.e. consider the following SELECT query.

    SELECT author_id, century FROM author_table WHERE author='انفسكم وقاتلوا'

When I fire this query from the application, this query doesn't return any value. But, if I take this exact same query, and run it in mysql, then I get the result alright. But, not from my web application.

I would like to assume the problem may not be with the Database, but rather J2EE application? Is this something anyone has already seen before, where comparing an arabic text returns no result, while there should be? Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Query Arabic text.
December 06, 2016 09:38AM
December 07, 2016 12:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.