We have table which consists of two different encoding data (utf8 and latin1) which has been inserted from two different use cases of application. We are getting broken strings issue for other languages text if we get the data in one encoding.We need to convert total table data into single encoding.
Eg: Table X id name data encoded 1 ébarber - utf8 2 à gogo - latin1
if we use "latin1" connection charset, we get issue with "ébarber"(broken strings). if we use "utf8" connection charset, we get issue with "à gogo"(broken strings).
How can we convert this table data into single encoding either utf8 or latin1? Please share your thoughts to fix this issue.