projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
f7bb848
)
UpdateDatabase/MysqlEngineCharset.php
author
Alan Knowles
<alan@roojs.com>
Wed, 6 Jan 2016 06:15:55 +0000
(14:15 +0800)
committer
Alan Knowles
<alan@roojs.com>
Wed, 6 Jan 2016 06:15:55 +0000
(14:15 +0800)
UpdateDatabase/MysqlEngineCharset.php
patch
|
blob
|
history
diff --git
a/UpdateDatabase/MysqlEngineCharset.php
b/UpdateDatabase/MysqlEngineCharset.php
index
0ebf09d
..
5354207
100644
(file)
--- a/
UpdateDatabase/MysqlEngineCharset.php
+++ b/
UpdateDatabase/MysqlEngineCharset.php
@@
-75,7
+75,8
@@
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");
+ // not sure why, but convert to does not actually change the 'charset=' bit..
+ $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";