| From: | Sebastien Flaesch <sebastien(dot)flaesch(at)4js(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Creating LATIN9 database with PostgreSQL 15 on Windows |
| Date: | 2022-10-20 15:32:06 |
| Message-ID: | DBAP191MB1289B63ABAD11E14F2711B8AB02A9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
On my Windows 10 with PostgreSQL 15, I try to create a database with LATIN9 encoding (for testing purpose), but I have only the choice to select the C, POSIX and English_United States.1252 collations...
C and POSIX are compatible with LATIN9, but SQL functions like UPPER() fail.
English_United States.1252 is not compatible with LATIN9.
I do not want to use WIN1252 encoding, I must use LATIN9 because it's for QA tests and my programs need LATIN9 (comes from Linux)
Do I have to create/install more locales on this PostgreSQL 15 / Windows installation?
I wonder... I while ago with PostgreSQL 13 I have created a DB with LATIN9 on this machine.
I must be missing something, can't remember how I did that.
Can someone point me to the doc page where I can find related info?
Thanks!
Seb
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastien Flaesch | 2022-10-20 15:55:48 | Re: Creating LATIN9 database with PostgreSQL 15 on Windows |
| Previous Message | Adrian Klaver | 2022-10-20 15:02:37 | Re: pg_restore 12 "permission denied for schema" errors |