diff options
| author | Kim Alvefur <zash@zash.se> | 2013-07-11 22:07:55 +0200 |
|---|---|---|
| committer | Kim Alvefur <zash@zash.se> | 2013-07-11 22:07:55 +0200 |
| commit | 567d00c04590e8db5553b567f8317ff455ab7f93 (patch) | |
| tree | e493acfddc1f79112f770cb9d96ba4837aaf684f | |
| parent | f5b5605db2d7c559d01e4a294be70cff718be60b (diff) | |
| download | prosody-567d00c04590e8db5553b567f8317ff455ab7f93.tar.gz prosody-567d00c04590e8db5553b567f8317ff455ab7f93.zip | |
util.sql: Set charset and collation for MySQL when creating tables
| -rw-r--r-- | util/sql.lua | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/util/sql.lua b/util/sql.lua index f360d6d0..771df7aa 100644 --- a/util/sql.lua +++ b/util/sql.lua @@ -264,6 +264,8 @@ function engine:_create_table(table) sql = sql.. ");" if self.params.driver == "PostgreSQL" then sql = sql:gsub("`", "\""); + elseif self.params.driver == "MySQL" then + sql = sql:gsub(";$", " CHARACTER SET 'utf8' COLLATE 'utf8_bin';"); end local success,err = self:execute(sql); if not success then return success,err; end |