PHP,PDO,UTF8和MySQL不玩球

我真的很想让 PHP通过PDO与UTF-8角色一起玩MysqL.

我使用PHP –version获得以下内容：

PHP 5.3.6 (cli) (built: Apr 19 2011 13:21:12)
Copyright (c) 1997-2011 The PHP Group
Zend Engine v2.3.0,Copyright (c) 1998-2011 Zend Technologies

这是来自MysqL cli的欢迎消息：

Server version: 5.1.57 Source distribution

我有这个作为我的数据库连接代码：

try {
    $dbh = new PDO('MysqL:host='.$server.';dbname='.$database.';charset=UTF8',$user,$password,array(PDO::MysqL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'"));
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}

我的PHP 代码插入MysqL：

$dbh->query("SET NAMES 'UTF8'"); 
$values = array(':idCode' => $idCode,':name' => $name,':address' => $address,':postcode' => $postcode,':tel' => $tel,':website' => $website,':disabled' => $disabled,':disabledWC' => $disabledWC,':description' => $description,':location' => $location,':type' => $type,':status' => $status,':image1name' => $image1name,':image2name' => $image2name,':image3name' => $image3name,':image4name' => $image4name,':image5name' => $image5name);
$preparedStatement = $dbh->prepare('UPDATE venues SET name = :name,address = :address,postcode = :postcode,tel = :tel,website = :website,disabled = :disabled,disabledWC = :disabledWC,description = :description,location = :location,type = :type,status = :status,date_modified = NOW(),image1name = :image1name,image2name = :image2name,image3name = :image3name,image4name = :image4name,image5name = :image5name WHERE idCode = :idCode');
$preparedStatement->execute($values);

我得到的问题是,即使我已经验证$description确实包含UTF8编码的字节(在网络上使用bin2hex和hex2UTF8工具),数据也不会通过连接提交为UTF-8并且我结束在数据库中使用“Générik”代替“Générik”.

我已经尝试在执行之前调用“SET NAMES UTF8”,我已经输入：

[client]
default-character-set=utf8

[MysqLd]
default-character-set=utf8

在我的my.cnf但似乎无法获得任何快乐.

有关如何使其工作的任何提示或提示？

我应该添加 – 如果我在命令行MysqL客户端手动输入文本它工作正常,该列设置为采取UTF8编码.

按要求 – 创建表脚本：

| venues | CREATE TABLE `venues` (
  `idCode` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(512) DEFAULT NULL,`address` varchar(1024) DEFAULT NULL,`postcode` varchar(32) DEFAULT NULL,`tel` varchar(32) DEFAULT NULL,`website` varchar(1024) DEFAULT NULL,`disabled` tinyint(4) DEFAULT NULL,`disabledWC` tinyint(4) DEFAULT NULL,`description` varchar(4096) CHARACTER SET utf8 DEFAULT NULL,`status` tinyint(4) DEFAULT NULL,`location` varchar(32) DEFAULT NULL,`type` varchar(32) DEFAULT NULL,`date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,`image1name` varchar(255) DEFAULT NULL,`image2name` varchar(255) DEFAULT NULL,`image3name` varchar(255) DEFAULT NULL,`image4name` varchar(255) DEFAULT NULL,`image5name` varchar(255) DEFAULT NULL,PRIMARY KEY (`idCode`)
) ENGINE=MyISAM AUTO_INCREMENT=129 DEFAULT CHARSET=latin1

和SELECT @@ character_set_database的结果：

SELECT @@character_set_database
    -> ;
+--------------------------+
| @@character_set_database |
+--------------------------+
| utf8                     |
+--------------------------+
1 row in set (0.00 sec)

而dumpParams的结果：

sql: [410] UPDATE venues SET name = :name,image5name = :image5name WHERE idCode = :idCode
Params:  17
Key: Name: [7] :idCode
paramno=-1
name=[7] ":idCode"
is_param=1
param_type=2
Key: Name: [5] :name
paramno=-1
name=[5] ":name"
is_param=1
param_type=2
Key: Name: [8] :address
paramno=-1
name=[8] ":address"
is_param=1
param_type=2
Key: Name: [9] :postcode
paramno=-1
name=[9] ":postcode"
is_param=1
param_type=2
Key: Name: [4] :tel
paramno=-1
name=[4] ":tel"
is_param=1
param_type=2
Key: Name: [8] :website
paramno=-1
name=[8] ":website"
is_param=1
param_type=2
Key: Name: [9] :disabled
paramno=-1
name=[9] ":disabled"
is_param=1
param_type=2
Key: Name: [11] :disabledWC
paramno=-1
name=[11] ":disabledWC"
is_param=1
param_type=2
Key: Name: [12] :description
paramno=-1
name=[12] ":description"
is_param=1
param_type=2
Key: Name: [9] :location
paramno=-1
name=[9] ":location"
is_param=1
param_type=2
Key: Name: [5] :type
paramno=-1
name=[5] ":type"
is_param=1
param_type=2
Key: Name: [7] :status
paramno=-1
name=[7] ":status"
is_param=1
param_type=2
Key: Name: [11] :image1name
paramno=-1
name=[11] ":image1name"
is_param=1
param_type=2
Key: Name: [11] :image2name
paramno=-1
name=[11] ":image2name"
is_param=1
param_type=2
Key: Name: [11] :image3name
paramno=-1
name=[11] ":image3name"
is_param=1
param_type=2
Key: Name: [11] :image4name
paramno=-1
name=[11] ":image4name"
is_param=1
param_type=2
Key: Name: [11] :image5name
paramno=-1
name=[11] ":image5name"
is_param=1
param_type=2

$description的记录十六进制字节(和预期的字符串值)：

Desctription: 526f756e64696e67206f6666205361747572646179206e6967687420696e20756e666f726765747461626c65207374796c652c204672656e636820636f6d70616e792047c3a96ec3a972696b20566170657572206272696e67207468656972206e65772073686f772057617465726c69747a20746f207468652048617420466169722e204174204b696e672047656f726765205620506c6179696e67204669656c64732c2042617220456e642e: Rounding off Saturday night in unforgettable style,French company Générik Vapeur bring their new show Waterlitz to the Hat Fair. At King George V Playing Fields,Bar End.

对于Générik这个词,你的“记录的十六进制字节”是0x47c3a96ec3a972696b.这确实是UTF-8编码的.您尝试验证存储数据的客户端几乎肯定在获取表内容之前设置了错误的字符集.

原文链接：https://www.f2er.com/php/134438.html

PHP,PDO,UTF8和MySQL不玩球

猜你在找的PHP相关文章