UPADATE no data change

[PAULO JOSE DE MELLO]

Hello team,

I need the following help, in mysql I did the update command as follows:

UPDATE lei_ocupacao_2020
SET state = 'Ceará'
WHERE state = 'CearÃi';

The command is accepted but does not change the line


I checked the condition and found that the word was registered in an encoding other than UTF-8

SHOW VARIABLES LIKE 'character_set%'


I tried to make the change by converting but without success

UPDATE bed_occupation_2020
SET state = CONVERT('Ceará' USING utf8)
WHERE state = 'CearÃi';

The error continues, what to do in this case?