Convert all the data of table (which have both encoding data) into single encoding either utf8 or latin1 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.
Depending on what RDBMS you are using:


You can try altering the Latin1-encoded column to use an encoding of UTF-8, if the RDBMS supports such an operation.

If you are using MySQL, you should look at this related Question on S.O.:
Converting mysql tables from latin1 to utf8
You can try:


Adding a new column with an encoding of UTF-8
UPDATE new_column = Latin1_column  (I am assuming that the RDBMS would be able to implicitly convert since it knows both encodings)
DROP Latin1_column
rename new_column to be former Latin1_column's name