MySQL table comments, field comments, and values are all garbled solutions

by 永夜 · 2021/04/07

浏览量： 0

1. The comments of the table are garbled. as shown in Figure 1

Figure 1

2. The comments of the fields are garbled. as shown in Figure 2

Figure 2

3. The values in the table are garbled. as shown in Figure 3

Figure 3

4. Add at the beginning of the sql file: set names utf8mb4;


SET NAMES utf8mb4;

5. Table comments, field comments, and values are no longer garbled. as shown in Figure 4

Figure 4