diff options
| -rw-r--r-- | fietsboek/models/__init__.py | 6 |
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. |