Commit1bf946b

committed

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 thatsomething like initdb --lc-collate=en-US would be needed to fix thatproblem for the initial template databases.Discussion:https://postgr.es/m/CA%2BhUKGJ_hk3rU%3D%3Dg2FpAMChb_4i%2BTJacpjjqFsinY-tRM3FBmA%40mail.gmail.com

1 parent4097233 commit1bf946bCopy full SHA for 1bf946b

File tree

-0

lines changed

-0

lines changed

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -985,6 +985,15 @@ CREATE COLLATION ignore_accents (provider = icu, locale = 'und-u-ks-level1-kc-tr`
`985`	`985`	`approach is imperfect as maintainers are free to back-port newer`
`986`	`986`	`collation definitions to older C library releases.`
`987`	`987`	`</para>`
	`988`	`+ <para>`
	`989`	`+ When using Windows collations, version information is only available for`
	`990`	`+ collations defined with BCP 47 language tags such as`
	`991`	`+ <literal>en-US</literal>. Currently, <command>initdb</command> selects`
	`992`	`+ a default locale using a traditional Windows language and country`
	`993`	`+ string such as <literal>English_United States.1252</literal>. The`
	`994`	`+ <literal>--lc-collate</literal> option can be used to provide an explicit`
	`995`	`+ locale name in BCP 47 format.`
	`996`	`+ </para>`
`988`	`997`	`</note>`
`989`	`998`	`</sect2>`
`990`	`999`	`</sect1>`

Comments

(0)