you not ADD Binary, you need to "remove" BINARY ... ;-)
Sorry, I misunderstood.
convert the string to latin1 or utf8 o.s.s.
"LOWER() (and UPPER()) are ineffective when applied to binary strings
(BINARY, VARBINARY, BLOB). To perform lettercase conversion, convert the
string to a non-binary string"
did you tried?
Well, I thought I had tried this, but with all the other things that I'd
tried, I guess I had everything mixed up. I started with a clean routine,
used Convert(... using UTF8), and it works perfectly now. That's what it
was.
Thanks for the help!
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]