Re: BUG #17058: Unable to create collation in version 13. - Mailing list pgsql-bugs

On Mon, Jun 14, 2021 at 12:31 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
> [PostgreSQL 13.3, compiled by Visual C++ build 1914, 64-bit]
>
> postgres=# CREATE COLLATION public.ja_jp (LOCALE = 'Japanese_Japan.932');
> ERROR:  could not get collation version for locale "Japanese_Japan.932":
> error code 87

Hmm.  I fixed this in 14 with:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=9f12a3b95dd56c897f1aa3d756d8fb419e84a187

Perhaps I should back-patch that to 13.  You can work around the
problem by using 'ja-JP' instead.  That's a "BCP 47 tag", which the
Windows documentation recommends[1].

[1]
https://docs.microsoft.com/en-us/cpp/c-runtime-library/locale-names-languages-and-country-region-strings?view=msvc-160