Re: Best way to store case-insensitive data?

From: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to store case-insensitive data?
Date: 2010-06-12 20:51:41
Message-ID: 201006122251.48612@fortytwo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 11 June 2010 09.27:15 Michal Politowski wrote:

[email address local part is case sensitive]

> In practice I've yet to see a system having both smith and Smith
> and them being different, but still it is theoretically posible.

I routinely modify email addresses I store to my addressbook to all
lowercase. I have yet to have a single case where this gets me into
problems; I think it's probably quite exotic to find a system that actually
is case sensitive.

cheers
-- vbi

--
featured product: ClamAV Antivirus - http://www.clamav.net/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-06-12 21:21:21 Re: Best way to store case-insensitive data?
Previous Message Adrian Klaver 2010-06-12 18:34:03 Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied