Column with utf-8 character error

Question

When executing:

SELECT campus_nome FROM cursosprounine where campus_nome like ('%?%')group by campus_nome;

to check the character error,

I found a code that taught me to convert the column:

UPDATE cursosprounine 
   SET campus_nome = CONVERT(CONVERT(CONVERT(campus_nome USING latin1) USING binary) USING utf8); 

but I noticed that the error continues in, VALPARAISO of GOI? S- Parque Esplanada III, and the right one is "VALPARAISO DE GOIÁS" in the shift column, I used the code: update cursosprounine set shift = 'Kurdish Away' Where turn = 'Kurdish to Dist? ncia' to correct the shift that were: Morning, Afternoon, Evening, Distance Course, as are few was quiet, but as this campus_name, I could not, help? p.s: correct the error of latin1/utf-8

Answer 1

Try this:

ALTER TABLE cursosprounine CHANGE COLUMN campus_nome campus_nome VARCHAR(500) CHARACTER SET utf8mb4