Re: BUG #18894: values of JLC_COLLATE and LC_CTYPE in the database have changed from Japanese_Japan.932 to ja-jp

The following bug has been logged on the website:

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.