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@xxxxxxxxxxx
