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
HTH
Steve
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
>(ORACLE_HOME,ORACLE_SID,NLS_LANG).
>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....
>
>
>Regards,
>
> 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]