Project

General

Profile

Characters get corrupt when I mysqldump the database contents

Added by Emre Akkas about 15 years ago

I dump the database contents with mysqldump using --default-character-set=utf8 (which is not technically necessary as utf8 is the default anyway). In the resulting sql file, the Chinese, Japanese, Russian, basically anything that does not belong to latin1 gets corrupt.

These characters look corrupt when I browse the production database using query browser also. However they are all fine through the Redmine GUI. Any ideas?

Thank you.