How to set encoding when connecting php to oracle

藏色散人
Release: 2023-03-11 07:40:01
Original
2332 people have browsed it

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');".

How to set encoding when connecting php to oracle

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');
Copy after login

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]));
}
Copy after login

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

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');
Copy after login

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');
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!