I have a table imported from a CSV with data containing the character "ñ (HTML entity ñ) (example: Niño). But after import, the table shows a "black diamond with question mark" character (�) in place of this ñ character. I tried doing this but no effect:
UPDATE myTable SET name=REPLACE(name, "�", "ñ");