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
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? |