# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1373573275 -7200
# Node ID 2e9ad9cb206fbaad2373055759d459e866901764
# Parent  2fb4f2ea27f4b49bb2111fdf99815e704b9aa88b
util.sql: Set charset and collation for MySQL when creating tables

diff -r 2fb4f2ea27f4 -r 2e9ad9cb206f 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