Fetch Oracle NLS Settings, Install Oracle Full Client in Zend Server.

Note that these results were not the ones I’d hoped for, the result was the installation of the full Oracle Instant client in PHP instead of the light version.

SELECT * FROM NLS_DATABASE_PARAMETERS;

	PARAMETER	VALUE
1	NLS_LANGUAGE	AMERICAN
2	NLS_TERRITORY	AMERICA
3	NLS_CURRENCY	$
4	NLS_ISO_CURRENCY	AMERICA
5	NLS_NUMERIC_CHARACTERS	.,
6	NLS_CHARACTERSET	WE8ISO8859P1
7	NLS_CALENDAR	GREGORIAN
8	NLS_DATE_FORMAT	DD-MON-RR
9	NLS_DATE_LANGUAGE	AMERICAN
10	NLS_SORT	BINARY
11	NLS_TIME_FORMAT	HH.MI.SSXFF AM
12	NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
13	NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
14	NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
15	NLS_DUAL_CURRENCY	$
16	NLS_COMP	BINARY
17	NLS_LENGTH_SEMANTICS	BYTE
18	NLS_NCHAR_CONV_EXCP	FALSE
19	NLS_NCHAR_CHARACTERSET	AL16UTF16
20	NLS_RDBMS_VERSION	9.2.0.7.0

To replace the light with the full client in Zend Server, put the “oraociei11.dll” (full) into the __ZendServerInstallPath__\ZendServer\bin directory and remove or rename the “oraociicus11.dll” (light). These libraries can be found in oracle client installation.