MySQL encoding problem
Posted
by heffaklump
on Stack Overflow
See other posts from Stack Overflow
or by heffaklump
Published on 2010-06-02T19:56:30Z
Indexed on
2010/06/02
20:04 UTC
Read the original article
Hit count: 261
I use Java and JDBC to save japanese characters and it works perfectly on my local MySQL. But when I tried doing the same thing on my web hotels MySQL i get ????? instead of japanese characters. I have made the exact same tables and use exact same code.
The only difference I have found is
SHOW VARIABLES LIKE 'CHAR%'
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /s/usr-local/share/mysql/charsets/
character_set_datbase is set to latin1. But I can't change it! Any tips?
© Stack Overflow or respective owner