MySQL garbled data due to UTF-8 double encoding

For example, you may have table with varchar, text or longtext fields and you may see garbled data in it. Though the text appears correctly on web pages, inside MySQL junk characters may appear. CREATE TABLE `my_news` ( `nid` bigint(10) NOT NULL DEFAULT '0', `title` text, `short_news` longtext) ENGINE=MyISAM DEFAULT CHARSET=utf8; In order to correct this error, try to alter the table in the following sequence. (more…)