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?
Asked
Active
Viewed 6,197 times
9
Ricardo Altamirano
- 14,650
- 21
- 72
- 105
NIKUNJ SANGHADIA
- 342
- 4
- 15
-
is the datatype of column is same as that of other two columns? – Ravi Jain Jun 12 '12 at 12:21
-
if you wish , you may contact the owner of http://stackoverflow.com/questions/6664831/mysql-sorting-non-english-string question regarding your problem. – Ravi Jain Jun 12 '12 at 12:26
2 Answers
8
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;
Community
- 1
- 1
Colin Pickard
- 45,724
- 13
- 98
- 148
-
Thank you my friend you saved my day.. Changing from PhpmyAdmin Panel was not working, Firing query worked at last. – Jaydeep Goswami Mar 07 '17 at 15:59
0
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
Bhavik Hirani
- 1,996
- 4
- 28
- 46