I Have a huge MySQL table with a long list of charities. Some of the charities have French characters in them which appear incorrectly.
For example I’m getting uppercase ‘É’ instead of ‘é’ in the middle of some names.
I’m wondering how I do a simple find change to correct this. I’d tried a few scripts but they don’t execute due to errors.
In this table find ‘É’ and replace with ‘é’.
UPDATE tbl SET col = REPLACE(col, 'É', 'é') COLLATE utf8_bin;
I don’t know if the
COLLATE clause is needed at all.
col is not
CHARACTER SET utf8, then use the appropriate “_bin” collation.
Test before applying:
SELECT col, REPLACE(col, 'É', 'é') FROM tbl WHERE col LIKE '%É%' LIMIT 22;