Character Set setting when PHP + OCI accesses the Oracle database -- sqlplus garbled Solution

1. Set the environment variable NLS_LANG
 
 
To solve the Oracle client garbled problem, the key is to unify the character set used by the server with the character set used by the client.
 
 
The Oracle client (Sqlplus, OCI, etc.) uses the NLS_LANG environment variable to determine the character set used by the client.
Example: export NLS_LANG = AMERICAN_AMERICA.AL32UTF8
How to view the character set used by the server: select userenv ('language') from dual;
 
 
2. Note that when PDO uses the utf8 character set, it uses charset to pass in: "UTF-8", with a '-' in the middle '-'.
 
Example: $ oradb = "oci: dbname = // www.carffee.com: 1521/npstores; charset = UTF-8 ";
 
 
 
--
Refer:
Http://www.bkjia.com/database/201202/120377.html
Http://www.bkjia.com/database/201202/120378.html

Author: simba