Table of Contents
回复讨论(解决方案)
Home Backend Development PHP Tutorial PHP连接ORACLE时乱码,手动PUTENV(NLS_LANG)环境变量后正常!

PHP连接ORACLE时乱码,手动PUTENV(NLS_LANG)环境变量后正常!

Jun 23, 2016 pm 01:13 PM

我有一个项目,从MYSQL迁移到ORACLE RAC中,数据库为UTF8编码格式,用PHP进行简单连接取出的中文均为问号,百度后发现在进行数据库连接时需要指定连接编码为UTF8,我指定了环境变量,并在测试页打印了PHP中全局环境变量,phpinfo(INFO_ENVIRONMENT),结果就正常了。如果不指定,PHP环境变量页面没显示nls_lang的变量信息,则依旧乱码,现在有什么办法,我有好几十个PHP页面,难道都要手动在开头PUTENV(NLS_LANG)定义一下么。求高手赐招能够在PHP服务运行时就自带环境变量nls_lang的参数。并自动在INFO_ENVIRONMENT显示成功。

补充下,我是centos6.5,已经在.bash_profile中定义了nls_lang。但貌似不起作用。PHP是5.6,WEB服务器是nginx 1.9


回复讨论(解决方案)

ORACLE 没有 utf8 只有 utf-8
你在链接 ORACLE 时就应声明所用字符集
只有 ORACLE 8 及以下,才需要设置环境变量

ORACLE 没有 utf8 只有 utf-8
你在链接 ORACLE 时就应声明所用字符集
只有 ORACLE 8 及以下,才需要设置环境变量


您说的对,但是有没有办法设置默认字符集,即和JAVA那样不在PHP连接字符串中
$conn = OCI_Logon('orcl','orcl','127.0.0.1/orcl','UTF8');或者putenv("NLS_LANG=american_america,UTF8");
Copy after login

两者都能够正常。我现在就是想和JAVA那样不用事先申明,因为我的TEST.PHP文本就是UTF8格式,数据库也是UTF8格式,应该能够自动匹配吧?

我手动输出系统环境变量nls_lang,结果是空的,
phpinfo(INFO_ENVIRONMENT);
?>
求赐教如何才能在PHP初始化的时候装载系统环境变量,换句话说如何指定PHP的环境变量,bash_profile不起作用。

写成 $conn = OCI_Logon('orcl','orcl','127.0.0.1/orcl','UTF8'); 就那么费事吗?
java 是通过 jdbc 进行数据库操作的,php 是通过客户端的
所以后者要多做一些设置上的事情

额,其实这公司是别的软件公司的产品,原生MYSQL,后来由于公司要求统一用ORACLE RAC数据库,迁移过去的。。好吧我找找他们的数据库连接是写在哪的,自己改下算了。

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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1666
14
PHP Tutorial
1272
29
C# Tutorial
1252
24
Explain secure password hashing in PHP (e.g., password_hash, password_verify). Why not use MD5 or SHA1? Explain secure password hashing in PHP (e.g., password_hash, password_verify). Why not use MD5 or SHA1? Apr 17, 2025 am 12:06 AM

In PHP, password_hash and password_verify functions should be used to implement secure password hashing, and MD5 or SHA1 should not be used. 1) password_hash generates a hash containing salt values ​​to enhance security. 2) Password_verify verify password and ensure security by comparing hash values. 3) MD5 and SHA1 are vulnerable and lack salt values, and are not suitable for modern password security.

PHP and Python: Comparing Two Popular Programming Languages PHP and Python: Comparing Two Popular Programming Languages Apr 14, 2025 am 12:13 AM

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

PHP in Action: Real-World Examples and Applications PHP in Action: Real-World Examples and Applications Apr 14, 2025 am 12:19 AM

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP: A Key Language for Web Development PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7

How does PHP type hinting work, including scalar types, return types, union types, and nullable types? How does PHP type hinting work, including scalar types, return types, union types, and nullable types? Apr 17, 2025 am 12:25 AM

PHP type prompts to improve code quality and readability. 1) Scalar type tips: Since PHP7.0, basic data types are allowed to be specified in function parameters, such as int, float, etc. 2) Return type prompt: Ensure the consistency of the function return value type. 3) Union type prompt: Since PHP8.0, multiple types are allowed to be specified in function parameters or return values. 4) Nullable type prompt: Allows to include null values ​​and handle functions that may return null values.

The Enduring Relevance of PHP: Is It Still Alive? The Enduring Relevance of PHP: Is It Still Alive? Apr 14, 2025 am 12:12 AM

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.

PHP vs. Other Languages: A Comparison PHP vs. Other Languages: A Comparison Apr 13, 2025 am 12:19 AM

PHP is suitable for web development, especially in rapid development and processing dynamic content, but is not good at data science and enterprise-level applications. Compared with Python, PHP has more advantages in web development, but is not as good as Python in the field of data science; compared with Java, PHP performs worse in enterprise-level applications, but is more flexible in web development; compared with JavaScript, PHP is more concise in back-end development, but is not as good as JavaScript in front-end development.

PHP and Python: Code Examples and Comparison PHP and Python: Code Examples and Comparison Apr 15, 2025 am 12:07 AM

PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.

See all articles