Redmine - cyrilic (russion) symbols looks like '??????'

Posted November 5, 2013 1.9k views
Redmine - cyrilic (russion) symbols looks like '??????'

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
4 answers
Run the following commands to fix that:
# Do a backup:

mysqldump redmine > redmine_backup.sql

# Convert to utf8

mysql --database=redmine -B -N -e "SHOW TABLES" | awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}' | mysql --database=redmine
Thank you !!! You realy help me.
Great quick fix, helped me too. You're the man!
I've updated the image so that it's set to utf8 by default.