diff options
| author | Thomas Munro <tmunro@postgresql.org> | 2021-04-16 13:20:58 +1200 |
|---|---|---|
| committer | Thomas Munro <tmunro@postgresql.org> | 2021-04-16 13:23:47 +1200 |
| commit | 1bf946bd43e545b86e567588b791311fe4e36a8c (patch) | |
| tree | fd3e23ced98b13af9a30e5419d92683c22e923d7 | |
| parent | 409723365b2708acd3bdf2e830257504bdefac4b (diff) | |
| download | postgresql-1bf946bd43e545b86e567588b791311fe4e36a8c.tar.gz postgresql-1bf946bd43e545b86e567588b791311fe4e36a8c.zip | |
Doc: Document known problem with Windows collation versions.
Warn users that locales with traditional Windows NLS names like
"English_United States.1252" won't provide version information, and that
something like initdb --lc-collate=en-US would be needed to fix that
problem for the initial template databases.
Discussion: https://postgr.es/m/CA%2BhUKGJ_hk3rU%3D%3Dg2FpAMChb_4i%2BTJacpjjqFsinY-tRM3FBmA%40mail.gmail.com
| -rw-r--r-- | doc/src/sgml/charset.sgml | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/src/sgml/charset.sgml b/doc/src/sgml/charset.sgml index 1b00e543a66..1c673cc1103 100644 --- a/doc/src/sgml/charset.sgml +++ b/doc/src/sgml/charset.sgml @@ -985,6 +985,15 @@ CREATE COLLATION ignore_accents (provider = icu, locale = 'und-u-ks-level1-kc-tr approach is imperfect as maintainers are free to back-port newer collation definitions to older C library releases. </para> + <para> + When using Windows collations, version information is only available for + collations defined with BCP 47 language tags such as + <literal>en-US</literal>. Currently, <command>initdb</command> selects + a default locale using a traditional Windows language and country + string such as <literal>English_United States.1252</literal>. The + <literal>--lc-collate</literal> option can be used to provide an explicit + locale name in BCP 47 format. + </para> </note> </sect2> </sect1> |