MySQL Forums
Forum List  »  Spanish

Cambiar de utf8 a utf8mb4_unicode_520
Posted by: carlos sanchez
Date: November 09, 2021 05:09PM

Hola a todos estoy tratando de cambiar a mysql 5.7 en Ubuntu las variables character y collation de utf8 a utf8mb4.
He mirado por internet y en el archivo /etc/my.cnf lo tengo asi:

default-character-set = utf8mb4

default-character-set = utf8mb4

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

Pero cuando hago:

show variables like '%colla%';
show variables like '%charac%';

Obtengo esta respuesta:

'collation_connection', 'utf8_general_ci'
'collation_database', 'utf8mb4_unicode_520_ci'
'collation_server', 'utf8mb4_unicode_ci'

'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'utf8mb4'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'utf8mb4'
'character_set_system', 'utf8'
'character_sets_dir', '/usr/share/mysql/charsets/'

¿Alguién podría explicarme como que puedo estar haciendo mal?

Options: ReplyQuote

Written By
Cambiar de utf8 a utf8mb4_unicode_520
November 09, 2021 05:09PM

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.