Re: PHP and OCI NLS behaviour
| From: | Paul Edmondson | Date: | Wed, 17 Apr 2002 15:32:40 +0000 |
| Subject: | Re: PHP and OCI NLS behaviour | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18602@lists.php.net to get a copy of this message | ||
The National Language Support settings can be set in a few ways. As an
environment variable which you have tried and had no luck with.
Or have you tried setting them in the init,ora file?
Or if that is not available for you to edit you could always try just
executing a statement to alter the session once a database connection is
established. This method is a little slower. As you will have to execute
the alter session statements every time you make the connection.
The SQL is something like:
alter session set NLS_LANGUAGE = 'AMERICAN' NLS_TERRITORY = 'AMERICA'
/
On Wed, 2002-04-17 at 15:48, Miguel Carvalho wrote:
> > Try lower case, as in
> >
> > export NLS_LANG=american_america.we8dec
> >
>
> I have already tried that....but no luck.
>
> Does any one have another tip... from the top of my head, i dont know what
> a can do more.
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
------------------------------------------------------------
Paul Edmondson, Software Engineer
Yospace: Creating Value for Wireless
7 The Courtyard, High Street, Staines, UK, TW18 4DR
Tel: +44 1784 466388
Fax: +44 1784 466387
http://www.yospace.com