从数据库检索utf-8数据 [英] utf-8 data retrieve from database

问题描述

我在数据库中有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数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！