diff options
| author | Erik Johnston <erik@matrix.org> | 2015-04-10 18:46:33 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-04-10 18:46:33 +0100 |
| commit | c5365dee564ffcf46300d1f979212e0ebaf98692 (patch) | |
| tree | d02d090ee1421fdb7560b085f0b4797a3b2cfa76 | |
| parent | DROP indexes before recreating them (diff) | |
| download | synapse-c5365dee564ffcf46300d1f979212e0ebaf98692.tar.xz | |
Use case sensitive collations
| -rwxr-xr-x | synapse/app/homeserver.py | 3 | ||||
| -rw-r--r-- | synapse/storage/engines/maria.py | 2 |
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) |