| 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? |