From f7bb8484e82857b9e0539da5fd567e3bcdb2a8f0 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Wed, 6 Jan 2016 14:15:34 +0800
Subject: [PATCH] UpdateDatabase/MysqlEngineCharset.php

---
 UpdateDatabase/MysqlEngineCharset.php | 1 +
 1 file changed, 1 insertion(+)

diff --git a/UpdateDatabase/MysqlEngineCharset.php b/UpdateDatabase/MysqlEngineCharset.php
index a00cce62..0ebf09d8 100644
--- a/UpdateDatabase/MysqlEngineCharset.php
+++ b/UpdateDatabase/MysqlEngineCharset.php
@@ -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";
             
-- 
2.39.2