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
 [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 09:01:30 2025 UTC