Re: utf8 vs UTF-8

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