mysql导入 指定utf8_TXT导入MYSQL 如何为UTF-8

$dbserv="localhost";$dbuser="root";$dbpass="vertrigo";$dbname="123456";$connect=mysql_connect("$dbserv","$dbuser","$dbpass");$f=file("1.txt");$q=count($f);for($i=0;$i

$dbserv="localhost";

$dbuser="root";

$dbpass="vertrigo";

$dbname="123456";

$connect=mysql_connect("$dbserv","$dbuser","$dbpass");

$f=file("1.txt");

$q=count($f);

for($i=0;$i

$arr=explode("|",$f[$i]); //建议文本文件中用“|”号分隔字段，用“,”的程序可读性差

print_r ($arr);

echo "

---

";

echo $q;

echo "

---

";

echo $buffer[0];

echo "

---

";

echo $arr[1];

echo "

---

";

echo $arr[2];

echo "

---

";

echo $arr[3];

echo "

---

";

echo $arr[4];

echo "

---

";

$query =@"INSERT INTO kt_sites(f_id,f_order,f_name,f_url,f_categoryId) VALUES ( ' ','$arr[1]','$arr[2]','$arr[3]','$arr[4]')";

$result=@mysql_db_query("$dbname",$query);

if($result)

{echo "数据导入成功"; }

else

{echo "数据已经导入，不能重复导入"; }

}

?>

入库以后就是乱码 怎么解决啊 不行啊 都是这样的þÄÏÉÌѧԺ TXT转换为UTF-8 导入也是一样乱码

展开