From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | vwu98034(at)lycos(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org, Lynna Landstreet <lynna(at)gallery44(dot)org> |
Subject: | Re: Unicode database question |
Date: | 2003-07-17 02:49:39 |
Message-ID: | 3F160EC3.3010103@cvc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Langille | 2003-07-17 02:56:47 | Re: Anyone used pgHoster.com? |
Previous Message | Dennis Gearon | 2003-07-17 02:41:07 | Re: Anyone used pgHoster.com? |