Re: [GENERAL] Unicode database question

[Dennis Gearon]

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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html