After installing Redmine on my Ubuntu 10.04 server from repositories I have noticed that international characters are shown as question marks (“?”). After some googling I found that MySQL tables and columns are not UTF8. Some more googling and I found a good tool to fix that.
The Phoca Changing collation tool changes the database collation of database, tables and columns. You can get it here (or my local copy). This is a php script. You need to copy it to your web server and run in your browser. Don’t forget to make a backup of your DB before doing anything.
