I'm trying to migrate a mysql database to heroku via db:push, which is of working fine, up to a point. I run heroku db:push mysql://dbuser:[email protected]/mydatabase?encoding=utf8 and it completes just fine (if I omit encoding=utf-8, I get an error). However, the special characters in the database are garbled: "Ålstensgatan 25c" => "Ã…lstensgatan 25c"
I suspect this MIGHT be due to the fact that the mysql database on the server isn't exactly vanilla UTF-8, but is instead utf8_unicode_ci. The problem is - how do I specify this in the encoding parameter? I have tried every permutation I can think of - utf8_unicode_ci, utf8-unicode-ci, utf8unicodeci etc. Lil' help? -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
