Re: PHP and OCI NLS behaviour

Try lower case, as in export NLS_LANG=american_america.we8dec -Stathis. Miguel Carvalho wrote: > > > > > > > Rouvas Stathis wrote: > >> Hi, > >> > >> place appropriate NLS_LANG definitions in the Apache startup script > >> (/etc/rc.d/apache ?). > > > > Ok, i have defined the NLS_LANG variable like this: > > export NLS_LANG=AMERICAN_AMERICA.WE8DEC > > and next i start apache > > Right know, i cant access the Oracle server. > I got this error: ORA-12705: invalid or unknown NLS parameter value > specified" > > I have searched for this error on OTN and on google, and it seams that the > NLS_LANG var is not correctly defined. I dont see any thing wrong. Does any > one see? > > The worse about this that the definition of NLS_LANG env var. on the client > is like the definition of the NLS setting that are on the server. > > NLS_DATABASE_PARAMETERS: > > NLS_LANGUAGE=AMERICAN > NLS_TERRITORY=AMERICA > NLS_CURRENCY=$ > NLS_ISO_CURRENCY=AMERICA > NLS_NUMERIC_CHARACTERS=., > NLS_DATE_FORMAT=DD-MON-YY > NLS_DATE_LANGUAGE=AMERICAN > NLS_CHARACTERSET=WE8DEC > NLS_SORT=BINARY > NLS_CALENDAR=GREGORIAN > NLS_RDBMS_VERSION=7.3.2.1.0 > > NLS_SESSION_PARAMETERS: > > NLS_LANGUAGE=AMERICAN > NLS_TERRITORY=AMERICA > NLS_CURRENCY=$ > NLS_ISO_CURRENCY=AMERICA > NLS_NUMERIC_CHARACTERS=., > NLS_DATE_FORMAT=DD-MON-YY > NLS_DATE_LANGUAGE=AMERICAN > NLS_SORT=BINARY > NLS_CALENDAR=GREGORIAN > > Does any one see a problem about this? > > Regards > Miguel Carvalho > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- +--------------+ |.------------.| || || || Stathis || || Rouvas || || || |+------------+| +-..--------..-+ .--------------. / /============\ \ / /==============\ \ /____________________\ \____________________/ rouvas@di.uoa.gr