Re: Use case for a "case insensitive equals" qualifier
Re: Use case for a "case insensitive equals" qualifier
- Subject: Re: Use case for a "case insensitive equals" qualifier
- From: Paul Hoadley <email@hidden>
- Date: Fri, 26 Feb 2016 10:15:21 +1030
| 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.
I think that’s where I’ll head. Has anyone used it?
|
_______________________________________________
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