Error changing charset using Mysql Table Editor from latin1 to utf8

Question

I am trying to change the charset, of a table directly in the database using Mysql Table Editor, from latin1 to utf8 however, by selecting utf8 in the charset options it automatically changes the collation to utf8mb4_general_ci and by having the changes applied returns me following error:

collation para utf8mb4_general_ci is not valid for character set utf8

Among the dozens of collations existing in the collation option which should be the correct?

Answer 1

So the correct is the one that attracts you, so it depends on the case any one can be the one such correct that you seek, now if you are wanting to use the pattern ABNT2 then a utf8 - default collation will solve.

Regarding error message, it seems you already have records in the table and these records cannot (is not valid) convert them to the other collation, a simple way to understand this is if you already have a type character c and wants to convert it to an American format where it does not exist, so it will generate an error.

but I’ll post a coded example:

ALTER TABLE `database`.`tabela` CHARACTER SET = utf8 ;

As per comments: php.ini file

has an excerpt of the code that must be commented, or if there is no

; PHP's default character set is set to empty.
; http://php.net/default-charset
;default_charset = "UTF-8"

Remove the character ; that is n beginning of the line ;default_charset = "UTF-8" and restart the apache service.

In the http.conf file there is also a line where a charset configuration is made:

#AddDefaultCharset utf-8

Same schema remove the first character and re-start the service