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.
Exactly what I was looking for, I don’t like the light client. Thank a lot for explaining how to do this!