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?
- is the datatype of column is same as that of other two columns?Ravi Jain– Ravi Jain2012-06-12 12:21:17 +00:00Commented Jun 12, 2012 at 12:21
- if you wish , you may contact the owner of stackoverflow.com/questions/6664831/… question regarding your problem.Ravi Jain– Ravi Jain2012-06-12 12:26:24 +00:00Commented Jun 12, 2012 at 12:26
Add a comment |
2 Answers
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; 
1 Comment
Jaydeep Goswami
Thank you my friend you saved my day.. Changing from PhpmyAdmin Panel was not working, Firing query worked at last.
Just you have to like ...
in Your Mysql DataBase Table.. Just Change 'Collation' of column Name. To 'utf8mb4_general_ci'.
and you can store any Gujarati font in database
