Copy Below Code View As A Text File Show Text Only Show API Edit Code

                            
ALTER TABLE tbl_name CONVERT TO CHARACTER SET latin1 COLLATE 'latin1_swedish_ci';


Link::: 
https://stackoverflow.com/questions/1241856/illegal-mix-of-collations-error-in-mysql