From: Richard Huxton <dev@archonet.com>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Subject: Re: Case sensitivity
Date: Mon, 12 Jan 2004 22:22:11 +0000
User-Agent: KMail/1.5
Cc: Dario Ottaviano <dario_ottaviano@togliquestovirgilio.it>,
	<pgsql-general@postgresql.org>
References: <Pine.LNX.4.33.0401121057560.19667-100000@css120.ihs.com>
In-Reply-To: <Pine.LNX.4.33.0401121057560.19667-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200401122222.11458.dev@archonet.com>

On Monday 12 January 2004 17:58, scott.marlowe wrote:
> On Mon, 12 Jan 2004, Richard Huxton wrote:
> > On Sunday 11 January 2004 09:29, Dario Ottaviano wrote:
> > > I use postgres on a window server (IIS 5.1)
> > > Is there anybody that knows if  is possible to make postgres  no case
> > > sensitive in the manipulating data into tables/views?
> >
> > There's no general "case_sensitive = yes/no" flag. There are
> > case-insensitive operators you can use though.
>
> Is there a case insensitive locale?  Or is that even possible?

I've heard it proposed, but don't believe anyone liked the idea enough to do 
it. With my limited understanding of encoding/locale issues, that'd mean 
adding support at the OS level, I think.

The other option would be an IVARCHAR type with suitably defined operators, 
but that's hardly very portable.
-- 
  Richard Huxton
  Archonet Ltd