It would sure be nice to be able to serve any language based on UTF-8 in
binary fields with no location rquired, and any sorting done either in
binary or through an additional SQL extension such as:
SELECT some_field
FROM some_table
WHERE xlate_utf8binary_to_collations( field_name_or_select_statement,
'lang1', lang2', ...) =
xlate_utf8binary_to_collations('some_value', 'lang1',
lang2', ...)
SORT BY xlate_utf8binary_to_collations('some_value', 'lang1', lang2', ...).
etc, etc, etc
Isn't postgres going to be importing some libraries for collations
sorting soon? I seem to remember coming upon some discussions involving
Tom and others about this.
