开发环境:linux 5.4 php5 apache unixodbc
数据库:linux 5.4 oracle 10.2
问题描述:
通过php向oracle中存入汉字时,存入数据库的都是乱码,但是通过windows客户端存入和读取汉字都正常,
数据库字符集:
NLS_LANGUAGE
AMERICANNLS_TERRITORY
AMERICANLS_CURRENCY
$NLS_ISO_CURRENCY
AMERICANLS_NUMERIC_CHARACTERS
.,NLS_CHARACTERSET
ZHS16GBKNLS_CALENDAR
GREGORIANNLS_DATE_FORMAT
DD-MON-RRNLS_DATE_LANGUAGE
AMERICANNLS_SORT
BINARYNLS_TIME_FORMAT
HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY
$NLS_COMP
BINARYNLS_LENGTH_SEMANTICS
BYTENLS_NCHAR_CONV_EXCP
FALSENLS_NCHAR_CHARACTERSET
AL16UTF16NLS_RDBMS_VERSION
10.2.0.1.0开发环境字符集:
SQL> select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL> more /etc/sysconfig/i18n 
LANG="en_US.UTF-8"/etc/profile已设置export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
/etc/init.d/httpd 已设置export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
请各位大侠帮忙找找原因,多谢!!