On Wed, Dec 31, 2008 at 1:27 PM, Ray Malone wrote:
> I can't seem to find documentation on how to filter a string value and
> expect a lower case value. For example if users input their names in
> upper and lower case I want to find the value using a lower case value
> later.
You'd need to store
I came up with the same approach, however, this is a unclean way to
handle it. Is this the only option?
On Dec 31, 10:42 am, "Rodrigo Moraes"
wrote:
> On Wed, Dec 31, 2008 at 1:27 PM, Ray Malone wrote:
> > I can't seem to find documentation on how to filter a string value and
> > expect a lower
In SQL, you simply compare the data value as lower or upper case,
which is the approach that is most often used to do a case-insensitive
match.
So you'd have something like:
WHEN UPPER(Mytable.myfield) = UPPER(?)
Or in Cake conditions, you'd do something like:
'(UPPER(Mytable.myfield))' => st