There is a MySQL `table` which has this definition taken from `SQLYog Enterprise` :


    Table              Create Table                                             
    -----------------  ---------------------------------------------------------
    etape_prospection  CREATE TABLE `etape_prospection` (                       
                         `etape_prosp_id` int(10) NOT NULL AUTO_INCREMENT,      
                         `type_prosp_id` int(10) NOT NULL DEFAULT &#39;0&#39;,          
                         `prosp_id` int(10) NOT NULL DEFAULT &#39;0&#39;,               
                         `etape_prosp_date` datetime DEFAULT NULL,              
                         `etape_prosp_comment` text,                            
                         PRIMARY KEY (`etape_prosp_id`),                        
                         KEY `concerne_fk` (`prosp_id`),                        
                         KEY `de_type_fk` (`type_prosp_id`)                     
                       ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1  

I want to change the `default charset` of this table from `latin1` to `utf8`. How to do that ?

All Sqlyog Solutions on Gang of Coders

Total of 1 Sqlyog Solutions

How to change the default charset of a MySQL table?