Inserting Gujarati text into a MySQL tables results in junk characters and unreadable text

Question

I have three MySQL tables and I'm inserting Gujarati content into them. When I insert two tables, they're inserted fine and are readable but in one table, it is showing junk characters/unreadable text. How can I fix this?

Answer 1

MySQL has per-table character set settings.

You can check which character set you are using for each table - see How do I see what character set a MySQL database / table / column is?.

If that is your problem, you might be able to covert the table in question, using:

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;