vs查询 mysql乱码

-- 查看数据库字符集和校对规则
SHOW CREATE DATABASE your_database_name;

-- 修改数据库字符集和校对规则
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 查看表字符集和校对规则
SHOW CREATE TABLE your_table_name;

-- 修改表字符集和校对规则
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

{
    "mssql.connections": [
        {
            "server": "your_server_address",
            "database": "your_database_name",
            "authentication": "SqlLogin",
            "username": "your_username",
            "password": "your_password",
            "options": {
                "charset": "utf8mb4"
            }
        }
    ]
}

mysqldump -u your_username -p your_database_name --default-character-set=utf8mb4 > backup.sql
mysql -u your_username -p your_database_name --default-character-set=utf8mb4 < backup.sql