Postgres Pro
Downloads
Home   >   mailing lists

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

From PG Bug reporting form
Subject BUG #18894: values of JLC_COLLATE and LC_CTYPE in the database have changed from Japanese_Japan.932 to ja-jp
Date
Msg-id 18894-be1784bdcbdc93e8@postgresql.org
Whole thread Raw
Responses Re: BUG #18894: values of JLC_COLLATE and LC_CTYPE in the database have changed from Japanese_Japan.932 to ja-jp
Re: BUG #18894: values of JLC_COLLATE and LC_CTYPE in the database have changed from Japanese_Japan.932 to ja-jp
List pgsql-bugs
Tree view 
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?

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #18885: ERROR: corrupt MVNDistinct entry - 2
Next
From: Gang Chen
Date:
Subject: 回复: BUG #18892: When the view already exists, CREATE OR REPLACE VIEW does not check whether the table exists.