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