Re: Can't use iso8859-2 with PHP+Oracle
| From: | Michael Virnstein | Date: | Wed, 22 May 2002 15:30:16 +0000 |
| Subject: | Re: Can't use iso8859-2 with PHP+Oracle | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19360@lists.php.net to get a copy of this message | ||
> 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
> >
> >
>
>