php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If 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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Wed Feb 05 11:01:31 2025 UTC