From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore |
Date: | 2020-03-29 17:49:17 |
Message-ID: | c8f8ede1-5b8c-27ff-6201-619668396008@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-03-29 18:01:09 | Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore |
Previous Message | Roman Gurinovich | 2020-03-29 12:57:06 | How to get char indices from text parser | tsvector? |