change data from latin1 to utf8

Question

I have a database with data in latin1 encoding format. I am trying to convert all the data into utf-8 as missing some finnish, dansish characters. I tried with the following commands.

 mysqldump --default-character-set=latin1 -u username -p -h example.com database_name > backup.sql
 iconv -f latin1 -t UTF-8 < backup.sql > converted-file.sql

but it is not working. Any help would be appreciated. thanks.

Take a look at this question: [link] http://stackoverflow.com/q/1440837/920359) — specificityy, Sep 26 '12 at 12:57

score 1 · Answer 1 · answered Sep 26 '12 at 12:48

1

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8

answered Sep 26 '12 at 12:48

AnandPhadke

13,160
5
26
33

I tried this command but it is converting the data in the table. thanks. – PlayLover Sep 26 '12 at 12:55
where is your source data resided? – AnandPhadke Sep 26 '12 at 12:57

change data from latin1 to utf8

1 Answers1