UpdateDatabase/MysqlEngineCharset.php
authorAlan Knowles <alan@roojs.com>
Wed, 6 Jan 2016 06:15:34 +0000 (14:15 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 6 Jan 2016 06:15:34 +0000 (14:15 +0800)
UpdateDatabase/MysqlEngineCharset.php

index a00cce6..0ebf09d 100644 (file)
@@ -75,6 +75,7 @@ class Pman_Core_UpdateDatabase_MysqlEngineCharset {
             //as the default collation for stored procedure parameters is utf8_general_ci and you can't mix collations.
             
             $ce = DB_DataObject::factory('core_enum');
+           $ce->query("ALTER TABLE $tbl CHARSET=utf8");
             $ce->query("ALTER TABLE {$tbl} CONVERT TO CHARACTER SET  utf8 COLLATE utf8_general_ci");
             echo "utf8: FIXED {$tbl}\n";