Use right collation when creating MySQL databases. Fixes #137

Reference: https://docs.moodle.org/30/en/MySQL#Creating_Moodle_database

diff --git a/mdk/db.py b/mdk/db.py
index da7c587..927f84e 100644 (file)
--- a/mdk/db.py
+++ b/mdk/db.py
@@ -99,7 +99,7 @@ class DB(object):
             pass
 
         if self.engine in ('mysqli', 'mariadb'):
-            sql = 'CREATE DATABASE `%s` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' % db
+            sql = 'CREATE DATABASE `%s` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci' % db
         elif self.engine == 'pgsql':
             sql = 'CREATE DATABASE "%s" WITH ENCODING \'UNICODE\'' % db