Posted by Jerry Stuckle on 06/20/05 15:44

lkrubner@geocities.com wrote:
> If I make this query with MySql:
>
> SELECT * WHERE keyword='urbanism'
>
> is the comparison case insensitive? Will MySql return all rows where
> keyword equals both 'urbanism' and 'Urbanism'?
>
> I searched this using Google Groups, and was suprised that there were
> no entries on this. This seems almost FAQ material.
>

Text columns are case insensitive. If you want case sensitivity, you
need to make the column BINARY. It's in the manual - if you know what
you're looking for.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: script in body
• Prev in forum: Re: Help with preg_replace
• Thread view: Re: are string matches in MySql normally case insenstive?

[Reply to this message]