Re: [SQL] ORDER BY collation order

2008-09-19 Thread Petr Jelinek
wait until per database collation is added (it was one of GSoC 08 projects and might get into 8.4) and then convince them to upgrade. -- Regards Petr Jelinek (PJMODOS) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [SQL] ORDER BY collation order

2008-09-19 Thread Petr Jelinek
;pg_config --configure" should show "--with-icu" as one of configure parameters. As user you could try SELECTing upper() or lower() on some text with more exotic chars (anything non-ASCII should do) in database which has UTF8 encoding. If it works then ICU support is there.