Convert MySql string ISO-8859-1 to UTF-8 with Java

Question

In a MySql database I have a column that contains a varchar string encoded with ISO-8859-1 (latin1_swedish_ci).

When the string is not latin1 MySql stores it, for example, as "à¸à¸µà¹à¸à¸."

Using Java I need to extract it and convert it to UTF-8.

Do you know how can I do it?

Thanks

You will need to add more detail on where the string comes from and how you are inserting it. — Pekka, Oct 18 '12 at 12:55
http://stackoverflow.com/questions/652161/how-do-i-convert-between-iso-8859-1-and-utf-8-in-java — silly, Oct 18 '12 at 12:55

Peter Lawrey · Answer 1 · 2012-10-18T13:24:30.010

3

Do you mean like ...

byte[] inIso_8859_1 = "à¸à¸µà¹à¸à¸.".getBytes("ISO-8859-1");
byte[] inUtf_8 = new String(inIso_8859_1, "ISO-8859-1").getBytes("UTF-8");

to check the UTF-8 encoding bytes

String s = new String(inUtf_8, "UTF-8");
System.out.println(s);

prints

à¸à¸µà¹à¸à¸.

edited Oct 18 '12 at 13:24

answered Oct 18 '12 at 12:55

Peter Lawrey

Thanks! but doing like that in some cases i have some characters not converted, or actually...they are, but i see ◻ Any ideas? – user1310165 Oct 18 '12 at 13:21
You have to ensure that you are displaying the UTF-8 correctly. – Peter Lawrey Oct 18 '12 at 13:23
1

Minor detail: what's "latin1" for MySQL is windows-1252 for the rest of the world. – Joni Oct 18 '12 at 18:09

1 Answers1