summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/testing/provision.py
diff options
context:
space:
mode:
Diffstat (limited to 'lib/sqlalchemy/testing/provision.py')
-rw-r--r--lib/sqlalchemy/testing/provision.py12
1 files changed, 9 insertions, 3 deletions
diff --git a/lib/sqlalchemy/testing/provision.py b/lib/sqlalchemy/testing/provision.py
index 687f84b18..8abfa3301 100644
--- a/lib/sqlalchemy/testing/provision.py
+++ b/lib/sqlalchemy/testing/provision.py
@@ -194,9 +194,15 @@ def _mysql_create_db(cfg, eng, ident):
_mysql_drop_db(cfg, conn, ident)
except Exception:
pass
- conn.execute("CREATE DATABASE %s" % ident)
- conn.execute("CREATE DATABASE %s_test_schema" % ident)
- conn.execute("CREATE DATABASE %s_test_schema_2" % ident)
+
+ # using utf8mb4 we are getting collation errors on UNIONS:
+ # test/orm/inheritance/test_polymorphic_rel.py"
+ # 1271, u"Illegal mix of collations for operation 'UNION'"
+ conn.execute("CREATE DATABASE %s CHARACTER SET utf8mb3" % ident)
+ conn.execute(
+ "CREATE DATABASE %s_test_schema CHARACTER SET utf8mb3" % ident)
+ conn.execute(
+ "CREATE DATABASE %s_test_schema_2 CHARACTER SET utf8mb3" % ident)
@_configure_follower.for_db("mysql")