Re: how to insert and get japanese characters.
Posted by: Tetsuro Ikeda
Date: May 26, 2005 01:10AM

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 SET autocommit=1
[/general log]

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

Options: ReplyQuote

Written By
Re: how to insert and get japanese characters.
May 26, 2005 01:10AM

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.