Java system charset, JDBC driver

[Max_Barel]

Copy from bugzilla update :
My two cents:
I'm on mysql 4.1.3 and connector/J 3.0.14.
I did not took the time to reproduce your problem.
From my experience, most of the charset problems since mysql >4 are from misunderstanding of the charset stack (sort of). There are a lot of different setting for charset and so conversion on the fly.

Here under is the listing of charset settings :
mysql> show variables like '%_set_%';
+---------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | XXXXX/mysql-standard-4.1.3-beta-apple-darwin7.4.0-powerpc/share/mysql/charsets/ |
+--------------------------+---------------------------------------------------------------------------------------------------+
7 rows in set (1.15 sec)

mysql>

When making tests, and then using the database, one must be sure that the whole charset flow is OK and there is no unexpected translation. From a terminal, for instance, be sure its setting is UTF-8...

[Max_Barel]

I forgot to mention that using the same command "show variables like '%_set_%';" from inside Neo/J show that the "character_set_client" and the "character_set_connection" are latin1.
This is normal since NeoJ/OOo uses latin1 internally.
The Connector output look then normal (latin1). I rather suspect that your input was incorrectly stored. I run in such situation when using different source to input in the database.

Max