本文介绍了从数据库检索utf-8数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在数据库中有utf-8-general-ci ..并将数据插入希伯来语langugae ..现在,当我检索数据时,它显示出像?????? ..这样的字符串.数据库连接就是这样.
I have utf-8-general-ci in database..and inserted data in hebrew langugae.. now when i retrieve data it displays me string like ??????..database connection is like this..
function __construct($strHost='', $strDB='', $strUser='', $strPass='')
{
try{
if($strHost != ''){$this->strHost = $strHost;}
if($strDB != ''){$this->strDB = $strDB;}
if($strUser != ''){$this->strUser = $strUser;}
if($strPass != ''){$this->strPass = $strPass;}
$this->objDB = new PDO("mysql:host=".$this->strHost.";port=3306;dbname=".$this->strDB,$this->strUser, $this->strPass, array( PDO::ATTR_PERSISTENT => true));
if($this->objDB)
{
return $this->objDB;
}
else
{
echo "Database Connection Failed.";die;
}
}
catch(Exception $objException)
{
echo $objException->getMessage();exit;
}
}
任何人都可以帮忙吗?
推荐答案
在PDO连接中将utf8添加为
Add utf8 in your PDO connection as
$this->objDB = new PDO("mysql:host=".$this->strHost.";port=3306;dbname=".$this->strDB, $this->strUser, $this->strPass,
array( PDO::ATTR_PERSISTENT => true,
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
阅读 http://php.net/manual/en/pdo.construct.php
这篇关于从数据库检索utf-8数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!