MySQL Forums
Forum List  »  Portuguese

UPADATE no data change
Posted by: PAULO JOSE DE MELLO
Date: April 16, 2023 06:01PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
UPADATE no data change
258
April 16, 2023 06:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.