CODEWITHSUNDEEP
mysqldatabasecollationcharset
Dimuth Nanayakkara
Dimuth Nanayakkara

Reputation: 1

Data set and collation in a Mysql DB

I created a database in Mysql for a record room mgt system using Sinhala character set. But when I export that database file and use it in another database(by importing) all the characters show as symbols(as I think Latin charset) Then I changed the character set of each table into utf8 format, but It's still displaying the same. How can I convert all the records I have entered(around 3500 records) into utf8mb4_general_ci format?

I changed the charset into utfmb4 but It didn't convert the existing records in my database

Upvotes: 0

Views: 41

Answers (0)

Related Questions