Re: Server locale?

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Server locale?
Date: 2002-10-07 07:28:16
Message-ID: 20021007092816.E32143@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Oct 05, 2002 at 08:39:39PM -0400, Tom Lane wrote:
> Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> > Can you retrieve what the server is using for LOCALE settings? In
> > particular, what the collate order is? It seems that my index is sorting
> > case insensetively, and I can't see a reason why.
>
> You can run contrib/pg_controldata (to become mainstream in 7.3 btw)
> to see the server's LC_COLLATE and LC_CTYPE settings.

and by "SHOW ALL" or SHOW LC_ [ COLLATE | ... ] commands too.

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Kubi 2002-10-07 07:46:54 Stored Procedures
Previous Message Karel Zak 2002-10-07 07:24:17 Re: [HACKERS] Advice: Where could I be of help?