Commit17d3233

committed

Update statement about sorting of character-string data.

The sort order is no longer fixed at database creation time, but can becontrolled via COLLATE. Noted by Thomas Kellerer.

1 parent4ec6581 commit17d3233Copy full SHA for 17d3233

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1050,8 +1050,13 @@ SELECT name FROM distributors ORDER BY code;`
`1050`	`1050`	`</para>`
`1051`	`1051`
`1052`	`1052`	`<para>`
`1053`		`- Character-string data is sorted according to the locale-specific`
`1054`		`- collation order that was established when the database was created.`
	`1053`	`+ Character-string data is sorted according to the collation that applies`
	`1054`	`+ to the column being sorted. That can be overridden at need by including`
	`1055`	`+ a <literal>COLLATE</> clause in the`
	`1056`	`+ <replaceable class="parameter">expression</replaceable>, for example`
	`1057`	`+ <literal>ORDER BY mycolumn COLLATE "en_US"</>.`
	`1058`	`+ For more information see <xref linkend="sql-syntax-collate-exprs"> and`
	`1059`	`+ <xref linkend="collation">.`
`1055`	`1060`	`</para>`
`1056`	`1061`	`</refsect2>`
`1057`	`1062`

Comments

(0)