Hi I'm having a problem with my code using OCIFetchInto function with Oracle.
here is the code!
$SQLSearch = "query goes here";
$rsResults = fnExecuteOracleSQLStatment($SQLSearch,$cnnOracle);
while (OCIFetchInto ($rsResults, $row, OCI_ASSOC))
{
echo $row['NAME'];
if ($row['APPROVALTYPEID'] != 5) {
$DocName = $row['NAME'];
if (strlen($DocName) == 0)
{
$DocName = "Untitled";
}
echo "Item : ".$row['NAME']."<br>";
}
}
ocifreestatement($rsResults);
And my question is ! this was working perfectly with field data type VARCHAR2. Once I have converted the VARCHAR2 type into LONG data type, It started giving some garbage characters+ the actual value in the field. What could be the problem ? Pls help!
Eg :- "��Test Dhanuka112121
(Test Dhanuka112121 is the actual value stored in the field.. you can see some garbage stuff in fron of the actual value)
