When I use mysqldump and then restore the character encoding is screwed up. Any idea hows?
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/