Database, MySql | 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.

STEP 1:

ALTER TABLE my_news MODIFY short_news longtext CHARACTER SET latin1;

ALTER TABLE my_news MODIFY short_news longtext CHARACTER SET binary;

ALTER TABLE my_news MODIFY short_news longtext CHARACTER SET utf8;

STEP 2:

After you connect to the database, make sure to set the character set to UTF-8 to ensure proper retrieval and storage.