Re: could not determine encoding for locale "et_EE.UTF-8": codeset is"CPUTF-8" in pg_restore

On 3/29/20 12:56 AM, Andrus wrote:
> Hi!
> 
>>> System Locale:             et;Eesti
>>> Input Locale:              et;Eesti
>> Hmm, I was expecting to see et_EE though I will admit to not truly 
>> understanding how Windows does locales.
>> I should have asked earlier, in the Postgres instance on Windows what 
>> does \l show for template0?


I rarely use Windows anymore so take the below with that in mind.

> 
> "D:\Program Files\PostgreSQL\12\bin\psql"  postgres postgres
> 
> psql (12.2)
> WARNING: Console code page (775) differs from Windows code page (1257)
>          8-bit characters might not work correctly. See psql reference
>          page "Notes for Windows users" for details.

There seems to a difference of opinion of what Baltic Code Page to use:

https://en.wikipedia.org/wiki/Code_page_775

https://en.wikipedia.org/wiki/Windows-1257

The post below shows a users method of dealing with this for another CP:

https://www.postgresql.org/message-id/549275CC.4010607%40gmail.com




> Type "help" for help.
> 
> postgres=# \l template0
>                                             List of databases
>    Name    |  Owner   | Encoding |        Collate        |         Ctype 
> |   Access privileges
> -----------+----------+----------+-----------------------+-----------------------+----------------------- 
> 
> template0 | postgres | UTF8     | Estonian_Estonia.1257 | 
> Estonian_Estonia.1257 | =c/postgres          +
>            |          |          |                       | | 

I'm guessing it is picking up Estonian_Estonia.1257 from the system.

The Windows Postgres instance was installed from the EDB installer?

> postgres=CTc/postgres
> (1 row)
> 
> Andrus.


-- 
Adrian Klaver
adrian.klaver@aklaver.com