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

From Tom Lane
Subject Re: utf8 vs UTF-8
Date
Msg-id 2388205.1715953909@sss.pgh.pa.us
Whole thread Raw
In response to utf8 vs UTF-8  (Troels Arvin <troels@arvin.dk>)
Responses Re: utf8 vs UTF-8
List pgsql-general
Troels Arvin <troels@arvin.dk> writes:
> 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

On most if not all platforms, both those spellings of the locale names
will be taken as valid.  You might try running "locale -a" to get an
idea of which one is preferred according to your current libc
installation ... but TBH, I doubt it's worth worrying about.

            regards, tom lane



pgsql-general by date:

Previous
From: Hans Schou
Date:
Subject: Re: utf8 vs UTF-8
Next
From: arun chirappurath
Date:
Subject: Execution history of a single query