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

On Mon, Apr 14, 2025 at 10:24 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 18894
> Logged by: xu bing
> Email address: bing(dot)xu(dot)uh(at)fujifilm(dot)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.
Thanks!
Manika Singhal
EDB India