• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Use case for a "case insensitive equals" qualifier
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Use case for a "case insensitive equals" qualifier


  • Subject: Re: Use case for a "case insensitive equals" qualifier
  • From: Theodore Petrosky <email@hidden>
  • Date: Thu, 25 Feb 2016 19:09:15 -0500

I’ve been following this conversation, quite interesting. But, and this is just a question for the conversation. Is there any reason when the user registers that the user name (email address) isn’t folded into lowercase and stored that way?

I might be missing something very obvious (as is usually the case).

Ted



On Feb 25, 2016, at 6:45 PM, Paul Hoadley <email@hidden> wrote:

On 25 Feb 2016, at 10:43 am, Paul Hoadley <email@hidden> wrote:

Can anyone suggest a better way? What I really need is a CaseInsensitiveEquals qualifier, like Java’s equalsIgnoreCase(). Is there such a thing? Would it be easily implemented?

Thanks for all the replies on this thread—much appreciated. The summary seems to be:

1. You can do this at the EOF level, perhaps with some minor gymnastics, and it might be inefficient.
2. You should probably do this at the database level, probably by using a collation on the column.

We’re using PostgreSQL (via Amazon RDS). Research is suggesting that PostgreSQL isn’t going to make this easy via a collation on a column, though there is the CITEXT type.

http://www.postgresql.org/docs/current/static/citext.html

I think that’s where I’ll head. Has anyone used it?


-- 
Paul Hoadley
http://logicsquad.net/


Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Use case for a "case insensitive equals" qualifier
      • From: Paul Hoadley <email@hidden>
References: 
 >Use case for a "case insensitive equals" qualifier (From: Paul Hoadley <email@hidden>)
 >Re: Use case for a "case insensitive equals" qualifier (From: Paul Hoadley <email@hidden>)

  • Prev by Date: Re: Use case for a "case insensitive equals" qualifier
  • Next by Date: Re: Use case for a "case insensitive equals" qualifier
  • Previous by thread: Re: Use case for a "case insensitive equals" qualifier
  • Next by thread: Re: Use case for a "case insensitive equals" qualifier
  • Index(es):
    • Date
    • Thread