Re: how to insert and get japanese characters.

[Tetsuro Ikeda]

Hi zif_web,

Generally, there is 2 possibility for facing such a quetion mark characters. one is table's charset, even if you have whole correct setting to connector/J. But as you say, you got correct japanese character from command line, so it means table setting is correct.

So, let's look at the 2nd possibility together. at first, please turn on the "mysql general log" and execute the java simple program which connect to server with connector/J.

Is your general log showing the mostly same to following?

[general log]
2 Connect @localhost as anonymous on test
2 Query SET NAMES utf8
2 Query SET character_set_results = NULL
2 Query SHOW VARIABLES
2 Query SHOW COLLATION
2 Query SET autocommit=1
[/general log]

I want to see "SET NAMES XXXX" and "SET character_set_results = XXX"