txt导入mysql乱码

$mysqli = new mysqli("host", "user", "password", "database");
$mysqli->set_charset("utf8");

ALTER DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

LOAD DATA INFILE 'path/to/file.txt' INTO TABLE table_name CHARACTER SET utf8 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';

<?php
$mysqli = new mysqli("host", "user", "password", "database");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// 设置连接字符集
$mysqli->set_charset("utf8");

// 导入数据
$sql = "LOAD DATA INFILE 'path/to/file.txt' INTO TABLE table_name CHARACTER SET utf8 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';";
if ($mysqli->query($sql) === TRUE) {
    echo "Data imported successfully";
} else {
    echo "Error importing data: " . $mysqli->error;
}

$mysqli->close();
?>