Postgres Pro
Downloads
Home   >   mailing lists

Re: utf8 vs UTF-8 - Mailing list pgsql-general

From Hans Schou
Subject Re: utf8 vs UTF-8
Date
Msg-id CAApBw35r0rLpeCTnMEF51_j4P7Nakooa+k6O_8gZ_vwwum4gEA@mail.gmail.com
Whole thread Raw
In response to utf8 vs UTF-8  (Troels Arvin <troels@arvin.dk>)
Responses Re: utf8 vs UTF-8
List pgsql-general
Tree view
> 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 PM Troels Arvin <troels@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":

  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





--
𝕳𝖆𝖓𝖘 𝕾𝖈𝖍𝖔𝖚
☏ ➁➁ ➅➃ ➇⓪ ➁⓪

pgsql-general by date:

Previous
From: Troels Arvin
Date:
Subject: utf8 vs UTF-8
Next
From: Tom Lane
Date:
Subject: Re: utf8 vs UTF-8