$firstName = $_POST["firstname"];
$lastName = $_POST["lastname"];
$age = $_POST["age"]; $oid = getUserOid();
$con = mysql_connect("localhost","root","339210");
if(!$con){
die("You could not connect the db!");
}
mysql_select_db("hejunlongtest1",$con);
$sql = "insert into person values('".$firstName."','".$lastName."','". $age."','".$oid."')";
mysql_query($sql, $con);
mysql_close($con);这段代码只能插进去英文,却插不进去中文,怎么回事?比如:fistName= He, lastName=jun age =12可插进去
fistName=何 lastName=jun age =12插不进去
总之,只要有汉字整条记录就插不进去(压根就插不进去,不是插进去乱码);
请教原因
MySQL 中文显示乱码
$lastName = $_POST["lastname"];
$age = $_POST["age"]; $oid = getUserOid();
$con = mysql_connect("localhost","root","339210");
if(!$con){
die("You could not connect the db!");
}
mysql_select_db("hejunlongtest1",$con);
mysql_query("SET NAMES 'utf8'");
$sql = "insert into person values('".$firstName."','".$lastName."','". $age."','".$oid."')";
mysql_query($sql, $con);
mysql_close($con);
ERROR 1366 (HY000): Incorrect string value: '\xBA\xCE' for column 'firstName' at
row 1
mysql>
看看firstName字段类型是什么?有没有指定字符集。
$lastName = $_POST["lastname"];
$age = $_POST["age"]; $oid = getUserOid();
$con = mysql_connect("localhost","root","339210");
if(!$con){
die("You could not connect the db!");
}
mysql_select_db("hejunlongtest1",$con);
mysql_query("SET NAMES = '页面编码'");
$sql = "insert into person values('".$firstName."','".$lastName."','". $age."','".$oid."')";
mysql_query($sql, $con);
mysql_close($con);