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

November 5, 2013 1.3k views
Redmine - cyrilic (russion) symbols looks like '??????'
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.
Have another answer? Share your knowledge.