[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Q: ignoring upper/lower case in SQL searches?
****** message to minivend-users from Alan Sparks <asparks@nss.harris.com> ******
Thanks for the reply. I've since come up with a quick workaround that's
not particularly clever, but works... I'm using Oracle, and yes, LIKEs
are quite case-sensitive.
-Alan
Dan Busarow wrote:
>
> ****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
>
> On Tue, 26 Jan 1999, Sparks, Alan wrote:
> > Is there a way to write a SQL search that ignores uppercase/lowercase
> > differences? I've tried building a search using the mv_search_field and
> > mv_orsearch type tags (since I have TWO fields to search), which works, but is
> > case sensitive.
>
> Which SQL database are you using? mysql is case-insensitive by default
> mSQL is case-sensitive by default. If you're using mSQL you may have
> to hack Data.pm (I think) to use CLIKE instead of LIKE.
>
> Pretty sure Oracle ignores case in LIKE's
>
> Dan
> --
> Dan Busarow 949 443 4172
> Dana Point Communications, Inc. dan@dpcsys.com
> Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
--
Alan Sparks, Network Administrator <asparks@nss.harris.com>
Harris Communications, Camarillo CA (805) 389-2430
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
