RE: Order changes in PG16 since ICU introduction
| От | Regina Obe |
|---|---|
| Тема | RE: Order changes in PG16 since ICU introduction |
| Дата | |
| Msg-id | 003b01d9747a$910471c0$b30d5540$@pcorp.us обсуждение |
| Ответ на | Re: Order changes in PG16 since ICU introduction (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Order changes in PG16 since ICU introduction
|
| Список | 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"
В списке pgsql-hackers по дате отправления: