Horton
Menu

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

PG Bug reporting form <noreply@postgresql.org>

View thread
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: bing.xu.uh@fujifilm.com
Date: 2025-04-14T06:08:13Z
Lists: pgsql-bugs 
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?