How do I force mysql to update when the only change is the case -

i changing case of data in table "title case". since mysql not have function title case, doing in php.

however, if data id = 1 "mr. john adams" then

update contacts set c_name = "mr. john adams" id = 1;

does nothing since mysql, being case insensitive, thinks nothing has changed.

i can't change mysql case sensitive in installation.

i tested in mysql , works, changes case on update. however, if doesn't work you, try this:

update contacts set c_name = binary 'john adams' id = 1

...and should work.

also try modifying columnn definition varchar(n) varbinary(n), may save having specify binary on each insert/update.

hth

francisco

Bready