commit f53ce24a102986ab907d75877e78209d557b7248 parent b46779de6c199f39589b3500c124dc38f25c9293 Author: Jan Dankert <devnull@localhost> Date: Fri, 30 Dec 2016 22:56:06 +0100 Mysql-Tabellen immer mit Charset=UTF-8 anlegen. Diffstat:
| db/DbVersion.class.php | | | 4 | ++-- |
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/db/DbVersion.class.php b/db/DbVersion.class.php @@ -75,8 +75,8 @@ abstract class DbVersion { $tableName = $this->getTableName($tableName); - $ddl = new Sql('CREATE TABLE '.$tableName.'(id INTEGER)'.($this->dbmsType=='mysql'?' ENGINE=InnoDB':'').';'); - // TYPE = InnoDB was deprecated in MySQL 5.0 and was removed in My SQL 5.1 and later versions. + $ddl = new Sql('CREATE TABLE '.$tableName.'(id INTEGER)'.($this->dbmsType=='mysql'?' ENGINE=InnoDB CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci':'').';'); + // The syntax 'TYPE = InnoDB' was deprecated in MySQL 5.0 and was removed in MySQL 5.1 and later versions. $this->db->query( $ddl ); }