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