Bug reference: 18894 Logged by: xu bing Email address: bing.xu.uh@fujifilm.com PostgreSQL version: 17.4 Operating system: windows server 2019 Datacenter Description:
In PostgreSQL 17.1, the values of JLC_COLLATE and LC_CTYPE in the database are Japanese_Japan.932. However, in PostgreSQL 17.4, they have changed to ja-JP. When upgrading from PostgreSQL 14.13 to PostgreSQL 17.4, the values of JLC_COLLATE and LC_CTYPE remain as Japanese_Japan.932.
I would like to know if this change affects data sorting and other operations. If it does, what parameters should be specified during the upgrade to change Japanese_Japan.932 to ja-JP?
Hi,
The updated installers for PostgreSQL 16 and 17 (package revision 2) are now available on our website for download.
These versions include support for selecting the locales in either of the following formats during installation:
BCP-47 names
Old style long names
Please try these new installers at your convenience and let us know if they work well for your setup.
