Apparently, from what I can find, MySQL 4.0x didn't have multiple
character/collation sets, but 4.1 does. When upgrading it labeled all
my columns as UTF8. I am guessing that UTF8 is case sensitive where
MySQL searches were case insensitive before. I tired changing the
lowercase 'a' and 'lz' to 'A' and 'Lz' in the below statement at it
started working. I then changed it back to lower case and changed the
column character set to ascii and ascii_general_ci for collation and
the original SQL statement started working again!
I recently upgraded my servers and in the process changed from
version 4.021 to version 4.1.12 of MySQL. The below search (which
gets saved as a var and inserted into an inline) was working fine and
I just noticed that it no longer works! Any ideas?
SELECT EmailAdd, Website, FirstName, LastName, BizName FROM Members
WHERE BizName BETWEEN 'a' AND 'lz' AND Approved = 'Yes' ORDER BY
It doesn't throw an error, just doesn't find anything. I believe it
has something to do with the "Between a and lz" part.
web << DESIGN >> print
PO Box 990872; Redding, CA 96099-0872
Attend the Lasso Summit
February 17-19, 2006 in Fort Lauderdale, FL