How can I remove question marks(not diamond shaped) from a latin1_general_ci MyISAM table?

I tried going back to utf8 and tried to apply things in https://stackoverflow.com/questions/1476356/detecting-utf8-broken-characters-in-mysql but it did not work, and some cannot work due to fulltext index of the fields.

Example field, viewing from directly database using phpmyadmin or heidisql:

"OSU ??? Oklahoma City"

1 Answer 1


so, I understand that you just want to remove '?' have you tried this:

UPDATE tablename SET column=REPLACE(column,'?','');

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.