Inserting Gujarati text into MySQL tables results in unwanted characters and unreadable texts

Question

I have three MySQL tables and I insert the contents of Gujarati into them. When I insert two tables, they are inserted and read, but garbage characters / unreadable text is displayed in one table. How can i fix this?

Answer 1

MySQL has character set settings in a table .

You can check which character set you use for each table - see How do I find out which character the MySQL database / table / column defines? .

If this is your problem, you can hide this table using:

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 

Answer 2

You just need to ...

in the Mysql database table. Just change the "Collation" of the Name column. To 'utf8mb4_general_ci'.

and you can save any Gujarati font in the database