I'm trying to upload Japanese characters into the db without success.
My tabels are set as default charset utf8.
I set my my.ini file as follows:
init-connect='SET NAMES utf8'
When I execute - show variables like '%character%';
character_set_client = latin1
character_set_connection = latin1
All others are set as utf8
How can I set those character sets to be utf8?
When I execute
mysql> Set character_set_connection=utf8;
I updates to utf8 but when I exit and restart the service it is changed back to latin1.
Can I modify them in my.ini file? I tried without success.
Again, All I want to do is to insert japanese chracters into my db.
I'm using java code to execute queries but I prefer to do the change in the configuration file.