Re: AW: [PHP-DB] php, OCI and datatypes

On Thu, Feb 14, 2002 at 11:13:00AM +0100, dsi safir wrote: > The "Hello" example (" H e l") comes from the sourcecode of > my browser. make sure that _ALL_ important environment vars are set (NLS_LANG seems to be missing/wrong in your case) tc > What's strange is that the two browsers (Netscape 4.03Fr and > IE 5.0) have different source code for the same page. > > It do seems that each CHAR that I manage to fetch is coded > with two places (in IE). > > I tried the following code for example with the same result > > <?php > print "<HTML><HEAD><TITLE>Nice Title, isn't > it</TITLE></HEAD><BODY><PRE>\n"; > $conn = OCILogon("XXXXX", "YYYYY", "ZZZBASEZZZ"); > $stmt = OCIParse($conn, "select CHAR_COL, > OTHER_DATATYPE_COL from CODE_FICHIER"); > OCIExecute($stmt); > // I fetch the five first rows > for ($i = 0; $i < 5; $i++) { > ocifetch($stmt); > $col_1 = ociresult($stmt, "CHAR_COL"); > $col_2 = ociresult($stmt, "OTHER_DATATYPE_COL"); > echo("\"$col_1\"\t\"$col_2\"\t\n"); > } > > echo ("</PRE></BODY></HTML>"); > ?> > The html source is : > <HTML><HEAD><TITLE>le titre</TITLE></HEAD><BODY><PRE> > " " "308" > " A B C" "626" > " " "702" > " A A N" "1108" > " " "1109" > " 7 5 1" "1112" > "" "" > "" "" > </PRE></BODY></HTML> >