Inserting Gujarati text into a MySQL tables results in junk characters and unreadable text
database, fonts, language-agnostic, mysql, mysql-error-1064
Solution
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;
Problem
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?