| From: | Petr Jelinek <pjmodos(at)pjmodos(dot)net> |
|---|---|
| To: | Joe <dev(at)freedomcircle(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: ORDER BY collation order |
| Date: | 2008-09-19 13:59:12 |
| Message-ID: | 48D3B030.6030500@pjmodos.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Joe wrote:
> Thanks for the info. The hosting company already offers 8.3
> databases. It's just that other things (we use tsearch2) have taken
> precedence over migrating to 8.3. How can I tell if the patch you
> mention is installed?
As admin (or somebody with shell access) by running "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.
--
Regards
Petr Jelinek (PJMODOS)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-09-19 14:26:00 | Re: ORDER BY collation order |
| Previous Message | Richard Huxton | 2008-09-19 10:37:59 | Re: pg_dump in windows |