> 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.
Petr Jelinek (PJMODOS)
In response to
pgsql-sql by date
|Next:||From: Scott Marlowe||Date: 2008-09-19 14:26:00|
|Subject: Re: ORDER BY collation order|
|Previous:||From: Richard Huxton||Date: 2008-09-19 10:37:59|
|Subject: Re: pg_dump in windows|