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: