mysql - navicate imports Chinese garbled characters into the database?

Question

1. Create a new people.xlsx table

2.Save as

3.Import database

4.Chinese garbled characters

Question: Why does garbled code appear? (Using Mysql database)

Re-did the above steps and changed the file format to csv and imported successfully.

Answer 1

The utf-8 of txt under window has encoding problem. It is not the format we usually think of. So it resulted in garbled code.