Rob Marscher wrote:
What's the charset and collation for the field? Maybe it's binary.
BINGO! somehow this table had gotten created with collation latin1_bin which I never even noticed. Thanks, Rob and Hans.
-- ================= Michael Southwell Vice President, Education NYPHP TRAINING: http://nyphp.com/Training/Indepth _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
