Re: sql search

["Phil Welch" <PhilmoreW@worldnet.att.net>]

http://www.tcx.se/Manual_chapter/manual_Problems.html#Case_sensitivity

17.13 Case sensitivity in searches
By default, MySQL searches are case-insensitive (although there are some
character sets that are never case insensitive, such as czech). That means
that if you search with col_name LIKE 'a%', you will get all column values
that start with A or a. If you want to make this search case-sensitive, use
something like INDEX(col_name, "A")=0 to check a prefix. Or use
STRCMP(col_name, "A") = 0 if the column value must be exactly "A".

Simple comparison operations (>=, >, = , < , <=, sorting and grouping) are
based on each character's "sort value". Characters with the same sort value
(like E, e and 'e) are treated as the same character!

LIKE comparisons are done on the uppercase value of each character (E == e
but E <> 'e)

If you want a column always to be treated in case-sensitive fashion, declare
it as BINARY. See section 7.6 CREATE TABLE syntax.

If you are using Chinese data in the so-called big5 encoding, you want to
make all character columns BINARY. This works because the sorting order of
big5 encoding characters is based on the order of ASCII codes.


----- Original Message -----
From: Andreas Kotowicz <koto@mynetix.de>
To: <minivend-users@minivend.com>
Sent: Sunday, July 18, 1999 6:11 AM
Subject: RE: sql search


> ******    message to minivend-users from Andreas Kotowicz
<koto@mynetix.de>     ******
>
> At 17:53 17.07.99 -0700, you wrote:
> >******    message to minivend-users from "Thompson-Jordan"
> ><Thompson-Jordan@mindspring.com>     ******
> >
> >mv_case=no (or cs=no)
>
> that one doesn't work as it is no command for sql search. Is there maybe
an
> option I have to set in MySQL?
>
>
> Andreas Kotowicz
> -
> 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