22979 Posts in 11815 Topics by 2826 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|