Re: Can't use iso8859-2 with PHP+Oracle
| From: | Michael Virnstein | Date: | Wed, 22 May 2002 21:25:53 +0000 |
| Subject: | Re: Can't use iso8859-2 with PHP+Oracle | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19366@lists.php.net to get a copy of this message | ||
Nope reviewed the oracle doc and EE8ISO8859P2 (ISO 8859-2 East European)
is correct. are you sure you set NLS_LANG for the apache user?
Regards Michael
"Michael Virnstein" <michael.virnstein@brodos.de> schrieb im Newsbeitrag
news:20020522153016.17985.qmail@pb1.pair.com...
> > The database nls_characterset and nls_nchar_characterset are also
> > EE8ISO8859P2.
>
> Oops, overwrote this...hmm...don't really know then.
> > EE8ISO8859P2
> hmm...not WE8ISO8859P2? but don't know exactly.
> for german it is GERMAN_GERMANY.WE8ISO8859P1
>
> Regards Michael
>
> "Michael Virnstein" <michael.virnstein@brodos.de> schrieb im Newsbeitrag
> news:20020522151534.2052.qmail@pb1.pair.com...
> > the character set of the database is perhaps ascii7bit.
> > change it to ascii8bit or to your ISO characterset,
> > using "alter database" command. Ascii8 is the most flexible and
> > should be used if you want to support more than one language.
> > Could be found here:
> >
http://technet.oracle.com/doc/oracle8i_816/server.816/a76966/ch3.htm#47136
> >
> > Regards Michael
> >
> > "Krzysztof Socki" <ksocki@onyx.pl> schrieb im Newsbeitrag
> > news:20020522130058.3024.qmail@pb1.pair.com...
> > > I put the characters '±æê³ñ󶼿' into the database with php
> > > script,
and
> I
> > > find the following in my table: '1fj3qs6<?'. I am using Oracle 8.1.7,
> PHP
> > > 4.1.1, Apache 1.3.22. I have set NLS_LANG=Polish_Poland.EE8ISO8859P2
in
> my
> > > environment and SetEnv=Polish_Poland.EE8ISO8859P2 in httpd.conf. The
> > > database nls_characterset and nls_nchar_characterset are also
> > EE8ISO8859P2.
> > > Does anyone know what I do wrong?
> > >
> > > Krzysztof Socki
> > > ksocki@onyx.pl
> > >
> > >
> >
> >
>
>