php - MySql database mixed character encoding in one column -

php - MySql database mixed character encoding in one column -

due unfortunate prior events, 1 of our legacy databases has columns latin1 , utf8 encoding mixed together, is, several columns have info might have both of encodings, while column default encoding latin1. there way observe encoding , convert them utf8

php mysql encoding utf-8 latin1