search

manno / frab

conference manangement system
7 stars 3 forks source link

utf8 foo - input encoding oder output decoding broken #41

Closed wingfire closed 12 years ago

wingfire commented 12 years ago

https://program.sigint.ccc.de/en/sigint12/public/speakers/74

manno commented 12 years ago

Had to fix the database, for some reason mysql stored utf8 in latin1 tables. Funny that worked for some views, but not for others. Now the tables are utf8, too.

For future reference:

mysqldump  --opt --quote-names --skip-set-charset --default-character-set=latin1 DATABASE | gzip > test.dump.gz
vi test.dump.gz 
# s/CHARSET=latin1/CHARSET=utf8/
zcat test.dump.gz | mysql  --default-character-set=utf8 DATABASE