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 1s7xyn-008e97-Bj for pgsql-general@arkaria.postgresql.org; Fri, 17 May 2024 13:50:38 +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 1s7xyn-00E1ex-9M for pgsql-general@arkaria.postgresql.org; Fri, 17 May 2024 13:50:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7xym-00E1ep-Uh for pgsql-general@lists.postgresql.org; Fri, 17 May 2024 13:50:36 +0000 Received: from mail-pl1-x636.google.com ([2607:f8b0:4864:20::636]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s7xyk-000fa7-FK for pgsql-general@lists.postgresql.org; Fri, 17 May 2024 13:50:35 +0000 Received: by mail-pl1-x636.google.com with SMTP id d9443c01a7336-1ee7963db64so9262755ad.1 for ; Fri, 17 May 2024 06:50:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715953833; x=1716558633; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=IctKKwQULEO1WdQM4LyVNg6X4INWLyM9AerBWjoINjo=; b=Ou5InFQP9Q1MVhTqjoSPbBjX12Tq+gfyvx3U+uZ9mu/qYq81BzA2LisIsRveFHKEvl 1ppHql4X5Y7Sp/37BvHxcFeUF4FpjKd8p54RlBU5rYVSrRbr6kTznyzcB2F+0c7V4Md6 sRGwhl0AO55VyW8TDZyJZUeWLKXi6kWb3P0aXw44QPsqlSwLhtRi5sC8NqFjXTX6J76N 851owsJ5sYHM8JVAZr7xyPsqq8MdiAdamzo+Rtyk/STZb5qqKh+JfhFxGzm5JdUZ55JC EAY/9QQVQSsCkquBK0/5M/4R9y1+JHPKOsY9JBmwY6hU1qLAgUMFXUSG/CBfp2L3t5Bc HsEw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715953833; x=1716558633; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=IctKKwQULEO1WdQM4LyVNg6X4INWLyM9AerBWjoINjo=; b=lOjnw+CE3aFABGCBkjULXTq1hBALE9oGR1GP/uE3Nciakbls+gMhW5pJ+rYsrQz4Bb 6dV10GWqoENdqAIYkdsZqLkcTyR7URKOYTZCdOy8/9zI+iV3V7Vpa/m3EvBgiLgArmyS zea8kAt/a3SEejz4m4sYYHwj8hoqNQy1AdmFn7LwIhkB5h1JwAgQZVMX5uQtvrx9Nhad Fh/mpGCiSFXKieOF5FxX0t3/G4RWn/De3HiV4ykwThzUS+ysOuoChrxooVfUReogNz+o Jw1VUrbJqoQuFDVC74SafeBhtH9AQWgLZDw4PL5DWriU4hObPoMIFlQaa+eAmKEY8QOG qwKw== X-Gm-Message-State: AOJu0Yz+lMxQNrUxvuv2lTJBgeBXfGOYThGz2A0ijJ/AWvDuirnC2hAa qCVPRV3prFnO9V7UDiUW27IK5aWR50K3o0yGSPH8JXU10K5ICk+5ohm/+ObgDPFkus7q/28HwW3 g8CJpEA7on4PRLzABb1qq0+l7sPIGJjG6 X-Google-Smtp-Source: AGHT+IGXoCag6bcNciu0QieAxf/mYL/+xpPLaNFZSOe5uBJg11OEYI4Flm7UnwvQyd4eh21vmPW4vV9VGRuY+lSblj4= X-Received: by 2002:a17:90b:11cc:b0:2b5:fce8:59f6 with SMTP id 98e67ed59e1d1-2b6cc14b924mr21025581a91.1.1715953833401; Fri, 17 May 2024 06:50:33 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Hans Schou Date: Fri, 17 May 2024 15:49:03 +0200 Message-ID: Subject: Re: utf8 vs UTF-8 To: Troels Arvin Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000b0f1610618a6a20f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b0f1610618a6a20f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable > test3 | troels | UTF8 | libc | en_US.utf8 | en_US.utf8 It is wrong but I guess it's working? how did you create test3? On Fri, May 17, 2024 at 2:44=E2=80=AFPM Troels Arvin wrot= e: > 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 > > > > --=20 =F0=9D=95=B3=F0=9D=96=86=F0=9D=96=93=F0=9D=96=98 =F0=9D=95=BE=F0=9D=96=88= =F0=9D=96=8D=F0=9D=96=94=F0=9D=96=9A =E2=98=8F =E2=9E=81=E2=9E=81 =E2=9E=85=E2=9E=83 =E2=9E=87=E2=93=AA =E2=9E= =81=E2=93=AA --000000000000b0f1610618a6a20f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
> test3=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | troe= ls=C2=A0=C2=A0 | UTF8=C2=A0=C2=A0=C2=A0=C2=A0 | libc=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | en_US.utf8 |=C2=A0 en_US.ut= f8

It is wrong but I guess it's working?
=

how did you create test3?

On Fri, May 17, 2024= at 2:44=E2=80=AFPM Troels Arvin <tro= els@arvin.dk> wrote:
Hello,

In a Postgres installation, I have databases where the locale is
slightly different. Which one is correct? Excerpt from "psql --list&qu= ot;:

=C2=A0=C2=A0test1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | loc_test | UTF8=C2= =A0=C2=A0=C2=A0=C2=A0 | libc=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 | en_US.UTF-8 |
en_US.UTF-8
=C2=A0=C2=A0test3=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | troels=C2=A0=C2=A0 = | UTF8=C2=A0=C2=A0=C2=A0=C2=A0 | libc=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | en_US.utf8 |
en_US.utf8

OS is Ubuntu.

--
Kind regards,
Troels Arvin





--
=F0=9D=95=B3=F0=9D=96=86=F0=9D=96=93=F0=9D= =96=98=C2=A0=F0=9D=95=BE=F0=9D=96=88=F0=9D=96=8D=F0=9D=96=94=F0=9D=96=9A
=E2=98=8F =E2=9E=81=E2=9E=81 =E2=9E=85=E2=9E=83 =E2=9E=87=E2=93= =AA =E2=9E=81=E2=93=AA
--000000000000b0f1610618a6a20f--