use utf8 connection for postgresHEADmaster

otherwise, we cannot use any unicode data in our strings

1 files changed, 5 insertions, 1 deletions

diff --git a/fietsboek/models/__init__.py b/fietsboek/models/__init__.py
index 004ed8e..b63d3ae 100644
--- a/fietsboek/models/__init__.py
+++ b/fietsboek/models/__init__.py
@@ -25,7 +25,11 @@ configure_mappers()
 
 def get_engine(settings, prefix="sqlalchemy."):
     """Create an SQL Engine from the given settings."""
-    engine = engine_from_config(settings, prefix)
+    kwargs = {}
+    if settings[f"{prefix}url"].startswith("postgres"):
+        kwargs["client_encoding"] = "utf8"
+
+    engine = engine_from_config(settings, prefix, **kwargs)
 
     # SQLite is quite loose with foreign keys by default, so make sure it
     # checks them.