Convert some special characters stored in a MySql
I am trying to convert some special characters stored in a MySql DB for display in Java.
Among the things I would like to convert are "á»…" to "ễ", "ç" to "ç", "ü" to "ü", etc.
My jdbc connection is Code:
jdbc:mysql://DBL_URL/NAME?requireSSL=false&useUnicode=true&characterEncoding=UTF-8
I'v tried with no luck:
Code:
byte[] stringBytes = dbString.getBytes();
String str = new String(stringBytes , "UTF-8");
A SHOW VARIABLES LIKE 'character_set%'; in mySql produces this:
Code:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir C:\Program Files\MySQL\MySQL Server 4.1\share\charsets/
Thanks