Hi Martin,

Try something along these lines ...

$query= "alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY'";

$curs = ociparse($conn,$query)  or die( "Unable to parse query" );

ociexecute($curs)  or die( "Unable to execute query" );

You can also set this in you init.ora file  i beleive

At 7:02 PM +0200 31/3/01, Martin Lustig wrote:
>Hi all,
>i have a trouble with settiong of environment for apache web server with php
>and oracle8i database.
>My connection to the database from php script thru OCI functions working but
>my problem is, that
>php script hasn't all environment variables from OS
>I have got national character in the database but response to my browser is
>converted to US7ASCII.
>I have already set .profiles for all users on the unix box (Solaris)
>including user nobody, which is used
>by apache. I did try tu use putenv() fro php for seting NLS_LANG variable
>without any change.
>Data are returned in US7ASCII.
>Have you anybody ideas how tu setup such environment? Probably i am not
>first who
>need apache, php and oracle operate....
>             Martin.
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

"Minds are like parachutes, they work best when open"
Support free speech; visit http://www.efa.org.au/

Heads Together Systems Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED]     Tel: 612 9982 6767     Fax: 612 9981 3081 

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to