Re: Java (EJB), Language other than English , and MySQL

[Ohad Raz]

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.