How should collations be made available?
Ideally, people should be able to specify a collation order for any set of data returned by a database query and sorted by a SQL ‘ORDER BY’ clause. Actual database implementations may differ in how they surface the choices of collations to users. Differing collations should also be specifiable for any comparison (e.g. s1 < s2) of strings, unless a strictly binary order comparison is intended. People should also be able to use collations for doing loose matching, and string searching.
