converting latin1 data into utf8 inside of an existing database
Following this answer:
MySQL - Convert latin1 characters on a UTF8 table into UTF8
you can make a function:
CONVERT(CAST(CONVERT(name USING latin1) AS binary) USING utf8)
and apply it.
How to convert mysql latin1 to utf8
I managed to solve it by running updates on text fields like this:
UPDATE table SET title = CONVERT(CONVERT(CONVERT(title USING latin1) USING binary) USING UTF8)
Related Topics
Create Date from Day, Month, Year Fields in MySQL
How Universal Is the Limit Statement in SQL
MySQL Subquery Returns More Than One Row
Check Whether String Is a Date Postgresql
Opinions on Sensor/Reading/Alert Database Design
SQL Server: Find Out Default Value of a Column with a Query
Creating or Simulating Two Dimensional Arrays in Pl/Sql
Scope_Identity VS Ident_Current
How to Join Two Recordset Created from Two Different Data Source in Excel Vba
Select Statement to Return Parent and Infinite Children
How to Compare 2 Rows from the Same Table (SQL Server)
Sorting Tree with a Materialized Path
How to Ignore "Duplicate Key" Error in T-SQL (SQL Server)
How to Convert Unix Epoch Time in SQLite