Re: Java (EJB), Language other than English , and MySQL
Posted by: Ohad Raz
Date: November 05, 2005 05:23AM

OK, I've found the solution:

I should have execute a:

SET NAMES <requested_char_set>;

statement on my DB.

For example, let's take my case, where I am using Hebrew.
The character set for hebrew is 'hebrew'. Therefore, the statement that needs to be executed is:

SET NAMES hebrew;

That have solved the problem for me!!!

Just to be on the safe side, I am attaching all the character set and collation settings:

character_set_client = 'hebrew';
character_set_connection = 'hebrew';
character_set_database = 'uf8';
character_set_results = 'hebrew';
character_set_server = 'uf8';
character_set_system = 'uf8';
collation_connection = 'hebrew_general_ci';
collation_database = 'utf8_unicode_ci';
collation_server = 'utf8_general_ci';

Again, this example is for using Hebrew.
Anyone who uses other language should replace the 'hebrew' with his/hers requested character set and collation.
Note, however, that the 'character_set_database' should be 'uf8', and that the 'collation_database' should be 'utf8_unicode_ci', since unicode is the character set used by Java.

Options: ReplyQuote

Written By
Re: Java (EJB), Language other than English , and MySQL
November 05, 2005 05:23AM

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.