util.sql: Set charset and collation for MySQL when creating tables
authorKim Alvefur <zash@zash.se>
Thu, 11 Jul 2013 22:07:55 +0200
changeset 5739 2e9ad9cb206f
parent 5738 2fb4f2ea27f4
child 5740 6fce00f61acf
util.sql: Set charset and collation for MySQL when creating tables
util/sql.lua
--- a/util/sql.lua	Thu Jul 11 15:13:45 2013 +0100
+++ b/util/sql.lua	Thu Jul 11 22:07:55 2013 +0200
@@ -264,6 +264,8 @@
 	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