On Thu, 12 Dec 2019, Andrew Gierth wrote:
Note that it's perfectly fine to use UTF8 encoding and C collation (this has the effect of sorting strings in Unicode codepoint order); this is as fast for comparisons as LATIN1/C is.
Andrew, This is really useful insight. I've not thought of the relationship of encoding to collation (which I now know there isn't.)
For those cases where you need data to be sorted in a culturally-meaningful order rather than in codepoint order, you can set collations on specific columns or in individual queries.
Not an issue for my work. :-) Thanks very much, Rich
