Mysql - Convertir todas las columnas en colación utf8
Consulta que permite convertir todas las tablas en colación utf8
Copy this code and paste it in your HTML
SELECT concat('alter table ', TABLE_NAME
, ' convert to character set utf8 collate utf8_unicode_ci;') WHERE table_schema
= 'db_clienteincognito' AND TABLE_COLLATION
<> 'utf8_unicode_ci'
/*verify all columns */
SELECT table_name
, column_name
, data_type
, character_set_name
, collation_name
FROM information_schema.
`COLUMNS` WHERE table_schema
= "db_clienteincognito";
Report this snippet
Comments
Subscribe to comments