Skip site navigation (1) Skip section navigation (2)

Re: ORDER BY collation order

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 (view raw or flat)
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)


In response to

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-09-19 14:26:00
Subject: Re: ORDER BY collation order
Previous:From: Richard HuxtonDate: 2008-09-19 10:37:59
Subject: Re: pg_dump in windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group