[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 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
