| From: | "Regina Obe" <lr(at)pcorp(dot)us> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "'Peter Eisentraut'" <peter(dot)eisentraut(at)enterprisedb(dot)com>, "'Sandro Santilli'" <strk(at)kbt(dot)io>, <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "'Jeff Davis'" <pgsql(at)j-davis(dot)com> |
| Subject: | RE: Order changes in PG16 since ICU introduction |
| Date: | 2023-04-21 18:13:49 |
| Message-ID: | 000001d9747d$066b7560$13426020$@pcorp.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Yeah. My recommendation is just LOCALE:
>
> regression=# CREATE DATABASE test1 TEMPLATE=template0 ENCODING =
> 'UTF8' LOCALE = 'C'; CREATE DATABASE regression=# CREATE DATABASE test2
> TEMPLATE=template0 ENCODING = 'UTF8' ICU_LOCALE = 'C';
> NOTICE: using standard form "en-US-u-va-posix" for locale "C"
> CREATE DATABASE
>
> I think it's probably intentional that ICU_LOCALE is stricter about being
given
> a real ICU locale name, but I didn't write any of that code.
>
> regards, tom lane
CREATE DATABASE test1 TEMPLATE=template0 ENCODING = 'UTF8' LOCALE = 'C';
Doesn't seem to work at least not under mingw64 anyway.
SELECT '+' < '-' ;
Returns false
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-04-21 18:23:45 | Re: Order changes in PG16 since ICU introduction |
| Previous Message | Tom Lane | 2023-04-21 18:06:57 | Re: Order changes in PG16 since ICU introduction |