23491 Posts in 18996 Topics by 2878 members
|Go to End|
1 September 2010 at 2:11am
When I use mysqldump and then restore the character encoding is screwed up. Any idea hows?
1 September 2010 at 5:23am
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.
25 October 2010 at 11:42pm
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.
25 October 2010 at 11:46pm
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/
|Go to Top|