On Jul 24, 2004, at 2:45 AM, Paolo Vernazza wrote:
[EMAIL PROTECTED] wrote:
How can a string be like something that has no wildcards, but not equal to it? My hunch is it has something to do with character encoding, but is that really how it should work?
Like is not case sensitive...
Hey, I never knew that--I always did LOWER(foo) LIKE '%whatever%', unnecessarily.
But the string in the database is definitely all lower-case. And, of course, when I try it again now it works correctly, the strings are equal and not just like.
Ugh.
-D
