From 16d7a7f4ac9afbb3b5c566af860f06cc236420c2 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 21 Jan 2025 14:25:04 -0600 Subject: [PATCH] Use a UTF-8 encoding for the db, with C collation --- db/run_createdb.m4 | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/db/run_createdb.m4 b/db/run_createdb.m4 index bc9678c..fa1c304 100644 --- a/db/run_createdb.m4 +++ b/db/run_createdb.m4 @@ -1,5 +1,5 @@ #!/bin/sh -# Copyright (C) 2023 The Meme Factory, Inc. http://www.karlpinc.com/ +# Copyright (C) 2023, 2025 The Meme Factory, Inc. http://www.karlpinc.com/ # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as published by @@ -25,8 +25,9 @@ include(`constants.m4')dnl sdb_generated_comment()dnl -createdb --encoding='SQL_ASCII' \ - --locale='C' \ +createdb --encoding='UTF8' \ + --lc-collate='C' \ + --lc-ctype='en_US.UTF-8' \ --template='template0' \ --owner='sdb_admin_group' \ --username="${ADMINUSER}" \ -- 2.34.1