Re: Oracle8i, PHP4, Apache

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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

-- --------------------------------------------------- "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: hts@hts.com.au Tel: 612 9982 6767 Fax: 612 9981 3081