At 10:35 AM -0500 6/22/99, Federico Giannici wrote:
>Jani Tolonen wrote:
>> What MySQL version are you using?
>Version 3.22.22 under OpenBSD 2.4 i386.
>> A char and a varchar -fields are always case-INsensitive,
>> unless the 'BINARY' attribute is given.
>> Text -fields are case-insensitive and blob -fields are case-sensitive.
>> (Blob is a binary field)
>Well, it doesn't work for me!
>I use the following WHERE clause:
>titolo REGEXP '[[:<:]]$keyword\[[:>:]]'
>Where titolo is a (not BINARY) varchar and $keyword is a perl variable.
>It works in a case insensitive way only if I convert both to lowercase
>What could be the reason?
REGEXP matching has its own rules, described in Appendix H of the MySQL
It does not appear to me that any of the rules there address case-insensitive
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/