php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #986 Problem with the german special characters
Submitted: 1998-12-10 11:36 UTC Modified: 1999-05-29 11:40 UTC
From: ulrich dot steinkopf at debis dot com Assigned:
Status: Closed Package: Oracle related
PHP Version: 3.0.5 OS: Solaris 2.6
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: ulrich dot steinkopf at debis dot com
New email:
PHP Version: OS:

 

 [1998-12-10 11:36 UTC] ulrich dot steinkopf at debis dot com
<HTML>
<HEAD>
<TITLE>TEST</TITLE>
</HEAD>
<BODY>
<H1> TEST <H1>

<?php
PutEnv("ORACLE_HOME=/u01/app/oracle/product/7.3.4");
PutEnv("ORACLE_SID=DEVL");
PutEnv("ORA_NLS32=/u01/app/oracle/product/7.3.4/ocommon/nls/admin/data");
PutEnv("NLS_LANG=german_germany");
PutEnv("TNS_ADMIN=$ORACLE_HOME/network/admin");

function str2html($string){
  
  $string=ereg_replace('?','&Auml;',$string);
  $string=ereg_replace('?','&Ouml;',$string);
  $string=ereg_replace('?','&Uuml;',$string);
  $string=ereg_replace('?','&auml;',$string);
  $string=ereg_replace('?','&ouml;',$string);
  $string=ereg_replace('?','&uuml;',$string);
  $string=ereg_replace('?','&szlig;',$string);
  $string=ereg_replace('?','&sect;',$string);

  return($string);
}

$conn_id=ora_plogon("infoville/infoville@infosol","");
$cur=ora_open($conn_id);

ora_parse($cur,"SELECT schluessel,bezeich FROM kategorie ");
ora_exec($cur);
while(ora_fetch($cur)==1){
  $key=ora_getcolumn($cur,0);
  $bez=ora_getcolumn($cur,1);
  
  $bez=str2html($bez);
  echo("<br> $key $bez \n");
}

ora_close($cur);

ora_logoff($conn_id);

?>
</BODY>
</HTML>

When i run this script under PHP-Apache-modul sometimes i get the german special characters and sometimes not. In table kategorie there are strings with german special characters in column bezeich.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-05-29 11:32 UTC] thies at cvs dot php dot net
this is almost for sure a problem with your NLS_LANG settings, please make sure that you apache runs with NLS_LANG german_germany.WE8ISO8859P1
 [1999-05-29 11:40 UTC] thies at cvs dot php dot net
forgot to change the state
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sun Oct 24 04:03:35 2021 UTC