So recently I have migrated from mssql to mysql using mysql workbench. Everything went smooth pretty much, I was able to copy the configs and it seems to run fine. However, I am faced with encoding problem. I was able to convert the database charset to utf8 collation as well as all the tables that still had latin1.
However, the output of ticket content in article body still isn't corrected. When I do select to see the article table, the output is in correct format and is readable. But the html output is not
. Did anyone had such a problem and maybe knows the solution? I will appreciate any help.