Fixing screwed up characters

I've been updating Ghost like crazy lately and just saw that the special characters in my db are all pretty much garbage:

ghost projekttel kísérleteztem már korábban, de még nagyon kezdetleges állapotban volt: konkrétan használhatatlan fázisban.\nMost teszek egy újabb próbát:\n`-talán ez bejön :)

Fixing posts

UPDATE posts
set

title = CONVERT(CAST(CONVERT(title USING latin1) AS BINARY) USING utf8)

,markdown = CONVERT(CAST(CONVERT(markdown USING latin1) AS BINARY) USING utf8)

,html = CONVERT(CAST(CONVERT(html USING latin1) AS BINARY) USING utf8)

,mobiledoc = CONVERT(CAST(CONVERT(mobiledoc USING latin1) AS BINARY) USING utf8)

Fixing tags

update tags set

name = CONVERT(CAST(CONVERT(name USING latin1) AS BINARY) USING
utf8)

Thats pretty much all you have to do..

Credits for original solution:

• http://stanis.net/2014/04/replacing-latin-1-with-utf-8-characters-in-mysql/
• Found via http://stackoverflow.com/questions/1476356/detecting-utf8-broken-characters-in-mysql/7302465#7302465