How to set oracle encoding in php

How to set Oracle encoding in php: 1. Get the character set of Oracle; 2. Run "select * from V$NLS_PARAMETERS;"; 3. Convert the encoding through the iconv function.

The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer

How to set oracle encoding in php?

php connects to oracle to set the character set to avoid garbled characters

The database uses oracle. When php connects to oracle, it is best to specify the character set.

Check the PHP manual. The fourth parameter of oci_connect is charset, which is the key.

First get the character set of oracle and run "select * from V$NLS_PARAMETERS;". The variable NLS_CHARACTERSET corresponds to the character set we need. For example, here is "ZHS16GBK". Therefore, the final PHP code is:

$c1 = oci_connect("scott", "tiger", $db, 'zhs16gbk');

My local PHP files use utf-8, so the obtained code needs to undergo the following encoding conversion:

while ($dat = oci_fetch_row($cur)) {
  print_r(iconv('gb2312', 'utf-8', $dat[0]));
}

Update:

Colleagues said that Oracle can provide data according to the character set specified by the client. In other words, if my local PHP file uses UTF-8, then when I use oci_connect, I can directly specify utf-8, and even the encoding conversion will be saved.

$c1 = oci_connect("scott", "tiger", $db, 'UTF8');

In addition, there is a strange problem: the iconv previously converted to the encoding worked normally in the test machine environment, but it could not be parsed properly when transmitted to the remote location. Later, it was replaced with mb_convert_encoding. The code is as follows:

$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');

The possible reason is whether "//IGNORE" is added to the second parameter in iconv. Please refer to http://cn2.php.net/manual/en/function.iconv.php. If you are interested, you can try it, but I won’t try it

In addition, I attach a self-packaged php method to query oracle data DingSql:

/**
* 封装接入oracle 执行sql语句查询
* @param sql
* @return false or string or array(array())
* @author xzz  2018年5月5日上午9:38:54
*/
function DingSql($sql = ''){
    header("Content-type: text/html; charset=utf-8");
    if(!$sql) return false;
    $conn= oci_connect('name', 'passwd', 'IP:PORT/serverName','zhs16gbk');
    if($conn) {
        $stid = oci_parse($conn, $sql); // 配置SQL语句，准备执行
        if (!$stid) {
            $e = oci_error($conn);
            print htmlentities($e['message']);
            exit;
        }
        $r = oci_execute($stid, OCI_DEFAULT); // 执行SQL。OCI_DEFAULT表示不要自动commit
        if(!$r) {
            $e = oci_error($stid);
            echo htmlentities($e['message']);
            exit;
        }
    
        $kkk = [];
        $i = '-1';
        while($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {//返回关联数据并创建null
            $i++;
            foreach($row as $key => $item) {
                $kkk[$i][$key] = iconv("gb2312", "utf-8//TRANSLIT", $item);
            }
        }
        oci_close($conn);
        return $kkk;    //二维关联数组
    }else{
        echo '连接oracle失败！';exit;
    }
}

Recommended learning : "PHP Video Tutorial"

The above is the detailed content of How to set oracle encoding in php. For more information, please follow other related articles on the PHP Chinese website!