Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7wwo-008XOt-OM for pgsql-general@arkaria.postgresql.org; Fri, 17 May 2024 12:44:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s7wwo-00CSwT-P8 for pgsql-general@arkaria.postgresql.org; Fri, 17 May 2024 12:44:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7wwo-00CSwL-BS for pgsql-general@lists.postgresql.org; Fri, 17 May 2024 12:44:30 +0000 Received: from home.borberg.arvin.dk ([194.45.76.153]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7wwj-000i5O-MW for pgsql-general@lists.postgresql.org; Fri, 17 May 2024 12:44:29 +0000 Received: from localhost (localhost [127.0.0.1]) by arvin.dk (Postfix) with ESMTP id A02BF27B59 for ; Fri, 17 May 2024 14:44:25 +0200 (CEST) X-Virus-Scanned: amavis at arvin.dk Received: from arvin.dk ([127.0.0.1]) by localhost (arvinserver4.home.borberg.arvin.dk [127.0.0.1]) (amavis, port 10024) with LMTP id zFHO10EE2TfT for ; Fri, 17 May 2024 14:44:24 +0200 (CEST) Received: from [192.168.1.8] (_gateway [192.168.1.1]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature ECDSA (P-256) server-digest SHA256) (No client certificate requested) by arvin.dk (Postfix) with ESMTPSA id 9D24A1FD3C for ; Fri, 17 May 2024 14:44:24 +0200 (CEST) DKIM-Filter: OpenDKIM Filter v2.11.0 arvin.dk 9D24A1FD3C DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=arvin.dk; s=202311171; t=1715949864; bh=I0gOjCNfBgP2rp/Jpn/Zog9J9WEwgvHfVr9iKGbWqyw=; h=Date:To:From:Subject:From; b=Dmc/GM9SNE9D2/FIxFrHGrTKv1WDvtxjmyGJTkbGYmpYp8f1bvfDB3UP9fbZTSDbE yyRxT7sreayqOKD7U/USuAOOEWqCUvovQrGMxmaOakCAl6ttOX1fuVRr5tB7SVyzNM UdZFm2o8VnC/6sI92F/WnNjWtZW7er2pYAo8NPTfUuapVt+ncee9OoA5ImQCBoKyuW vwXQitEGJXNl4fUmRp+DOxFKAnbxzdrwC289+ZbZghvSITKYy2DXRGcd/UhIwC9/PU O9uflfUw/ryrnd/qr7PtwtVeX1AJKmUbxzZHXW/3JjYRU/B7wZiABMtLdKkk/BkysK M0nBC/wzjRB1w== Message-ID: Date: Fri, 17 May 2024 14:44:24 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird To: pgsql-general@lists.postgresql.org Content-Language: en-US From: Troels Arvin Subject: utf8 vs UTF-8 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, In a Postgres installation, I have databases where the locale is slightly different. Which one is correct? Excerpt from "psql --list":  test1       | loc_test | UTF8     | libc            | en_US.UTF-8 | en_US.UTF-8  test3       | troels   | UTF8     | libc            | en_US.utf8 | en_US.utf8 OS is Ubuntu. -- Kind regards, Troels Arvin