summary refs log tree commit diff
path: root/synapse
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-04-10 18:46:33 +0100
committerErik Johnston <erik@matrix.org>2015-04-10 18:46:33 +0100
commitc5365dee564ffcf46300d1f979212e0ebaf98692 (patch)
treed02d090ee1421fdb7560b085f0b4797a3b2cfa76 /synapse
parentDROP indexes before recreating them (diff)
downloadsynapse-c5365dee564ffcf46300d1f979212e0ebaf98692.tar.xz
Use case sensitive collations
Diffstat (limited to 'synapse')
-rwxr-xr-xsynapse/app/homeserver.py3
-rw-r--r--synapse/storage/engines/maria.py2
2 files changed, 2 insertions, 3 deletions
diff --git a/synapse/app/homeserver.py b/synapse/app/homeserver.py
index fbc9a43d66..a47e548d66 100755
--- a/synapse/app/homeserver.py
+++ b/synapse/app/homeserver.py
@@ -363,7 +363,6 @@ def setup(config_options):
 
     db_config = {
         k: v for k, v in db_config.items()
-        if not k.startswith("cp_")
     }
 
     name = db_config.get("name", None)
@@ -372,7 +371,7 @@ def setup(config_options):
             "sql_mode": "TRADITIONAL",
             "charset": "utf8mb4",
             "use_unicode": True,
-            "collation": "utf8mb4_general_ci",
+            "collation": "utf8mb4_bin",
         })
     elif name == "sqlite3":
         db_config.setdefault("args", {}).update({
diff --git a/synapse/storage/engines/maria.py b/synapse/storage/engines/maria.py
index c934376930..90165f6849 100644
--- a/synapse/storage/engines/maria.py
+++ b/synapse/storage/engines/maria.py
@@ -36,7 +36,7 @@ class MariaEngine(object):
     def prepare_database(self, db_conn):
         cur = db_conn.cursor()
         cur.execute(
-            "ALTER DATABASE CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci"
+            "ALTER DATABASE CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
         )
         db_conn.commit()
         prepare_database(db_conn, self)