Re: [PHP-DB] Oracle 8i + PHP4: character set

2001-05-04 Thread Thies C. Arntzen

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Oracle 8i + PHP4: character set

2001-05-04 Thread Miguel

I've the same problem, however if I try to set NLS_LANG other than the
default I receive a segmentation fault in the apache server (using Linux).

Thies C. Arntzen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 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

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]