Thimble Smith wrote:
> At 19:49, 19990804, toxalot@stripped wrote:
> >I read up on it and there doesn't seem to be a way to ignore case like you
> >can with perl. It explains how to match the lower or uper case version.
> >Does that mean that I will have to manually alter the keyword that the user
> >enters into my text box to be any mix of upper and lower case? Or is there
> >a way around this?
> If case isn't going to be important, I'd recommend storing the text in
> the database all in lower case, and converting the words the user enters
> to lower case before doing the search. Or, you can use something like:
> SELECT id FROM table_name WHERE LCASE(field) REGEXP "[[:<:]]word[[:>:]]"
If you use different languages, you should store them in UPPERCASE.
In some languages there are characters, which have two different lowercase representations
but only one uppercase.