When I use mysqldump and then restore the character encoding is screwed up. Any idea hows?
We've moved the forum!
Please use forum.silverstripe.org for any new questions
(announcement).
The forum archive will stick around, but will be read only.
You can also use our Slack channel
or StackOverflow to ask for help.
Check out our community overview for more options to contribute.
You can specify a character set encoding for dumping mysql data. by default it is utf8 (at least on my system). this might be not the encoding silverstripe created your tables with.
Mysql has a double encoding problem, screws up the characters of you upgrade and use:
MySQLDatabase::set_connection_charset('utf8'); Which I hadn't tried to remove.
add 'SET sql_mode = 'ANSI';' to the top of the script before running it?
also I'd suggest using... http://www.silverstripe.org/database-plumber-module/