View Single Post
  #1 (permalink)  
Old 07-17-2007, 05:28 PM
romina romina is offline
Member
 
Join Date: Jul 2007
Posts: 26
romina is on a distinguished road
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
Reply With Quote
Sponsored Links