oracle date field and win32/unix

[Anon]

This is a question for those guys, who works with unix (because I haven't got enough practice of it).
The talk is about i have currently working php3/apache/win32 and php3/apache/solaris. Plus oracle8 under solaris.
I wanna make them booth to work properly.
But I'v got a problem in exchanging data with oracle database.
F.e. I add a date value (let it be 10.01.2000) and then read it. The result is:
under win32 I get 10.01.2000, but under unix I get 10-JAN-00. How could it be if in booth cases I operate the same oracle servered database?
Else If trying to put some text in windows-1251 charset into the database under unix It's modified then into some @!#$ while under win32 all is OK. The same is with reading text from oracle db.
I'm not quite shure that it's because of php not because of apache. Anyways I still can't coope with this.
Thank you all.
Alex.

[Anon]

It is because of your language parameter for your Oracle DB. They seem not to be the same for the 2 OS.

There are many parameters you can set to change language, number and date format in Oracle.

NLS_LANG: Global language
NLS_DATE_FORMAT: Date format
NLS_DATE_LANGUAGE: Date Language
... and much more ...
Read Oracle manual for details

Win32: Look in the registry
HKEY_LOCAL_MACHINE/software/Oracle to set parameters

Unix: Set corresponding env vars

Hth

JBL