| 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 17:56:14 |
| Message-ID: | 003b01d9747a$910471c0$b30d5540$@pcorp.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > CREATE DATABASE test TEMPLATE=template0 ENCODING = 'UTF8'
> LC_COLLATE = 'C'
> > LC_CTYPE = 'C';
>
> As has been pointed out already, setting LC_COLLATE/LC_CTYPE is
> meaningless when the locale provider is ICU. You need to look at what ICU
> locale is being chosen, or force it with LOCALE = 'C'.
>
> regards, tom lane
Okay got it was on IRC with RhodiumToad and he suggested:
CREATE DATABASE test2 TEMPLATE=template0 ENCODING = 'UTF8' LC_COLLATE = 'C'
LC_CTYPE = 'C' ICU_LOCALE='C';
Which gives expected result:
SELECT '+' < '-' ; -- true
but gives me a notice:
NOTICE: using standard form "en-US-u-va-posix" for locale "C"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-04-21 17:59:42 | Re: Order changes in PG16 since ICU introduction |
| Previous Message | Tom Lane | 2023-04-21 17:46:25 | Re: Order changes in PG16 since ICU introduction |