How to set encoding when connecting php to oracle

How to set the encoding when connecting to oracle in php: first get the character set of oracle; then set the PHP code to "oci_connect("scott", "tiger", $db, 'zhs16gbk');".

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

How to set the encoding when connecting to oracle with 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:

Php code

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

My local PHP files use utf-8, so the obtained code must be encoded as follows Conversion:

Php code

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

-------------------------- -----

renew

--------------------------------

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.

Php code

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

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

Php code

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

The possible reason is whether the second parameter in iconv is added "//IGNORE" ”, 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

Recommended study: "PHP Video Tutorial"

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