Advanced Search

Return to Snippet

Revision: 68980
at March 30, 2015 05:44 by ironcrema
Updated Code 
SELECT concat('alter table ', TABLE_NAME , ' convert to character set utf8 collate utf8_unicode_ci;')
FROM information_schema.TABLES
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";

Revision: 68979
at March 30, 2015 04:54 by ironcrema
Initial Code 
SELECT concat('alter table ', TABLE_NAME , ' convert to character set utf8 collate utf8_unicode_ci;')
FROM information_schema.TABLES
WHERE table_schema = 'db_clienteincognito'
AND TABLE_COLLATION <> 'utf8_unicode_ci'
Initial URL 









Initial Description





Consulta que permite convertir todas las tablas en colación utf8









Initial Title





Mysql - Convertir todas las columnas en colación utf8









Initial Tags





convert









Initial Language





MySQL