Re: Oracle 8i + PHP4: character set
| From: | Thies C. Arntzen | Date: | Fri, 04 May 2001 14:07:03 +0000 |
| Subject: | Re: Oracle 8i + PHP4: character set | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9126@lists.php.net to get a copy of this message | ||
On Fri, May 04, 2001 at 03:50:34PM +0200, Stefan Fokuhl wrote:
> Hello,
>
> I do have a little tiny problem with the character set.
>
> If I try to insert a word containing an german umlaut by a php-script,
> Oracle strips the seventh bit. I.e. "ä" becomes a "d". In PHP the SQL
> statement is written correctly.
>
> Facts:
>
> 1. I use Oracle 8i. The DB is made with the we8iso8859p1 option.
> 2. The NLS_LANG is set to GERMAN_GERMANY.WE8ISO8859P1
> 3. SQLPLUS works fine.
make sure to set NLS_LANG _before_ apache gets started (eg in
the /etc/init.d/httpd script).
tc