SQL2K5-PHP CTP - Bug In Sqlsrv_stmt_fetch_array With Large (&&>65535) Text

On SQL2005, we have a table called Document_lie with 2 fields : doc_type (varchar(50)) and doc_Document (text).

Another application is putting base64 encoded text in doc_document.

This code works:

$sql=" Select Top 1 DOC_Type,DOC_Document from Document_lie

where Doc_Compteur =7418;

";

$stmt=sqlsrv_conn_execute($conn,$sql);

if ($stmt) {

sqlsrv_stmt_fetch( $stmt );

$typedocu=sqlsrv_stmt_get_field($stmt,1);

$photostream=sqlsrv_stmt_get_field($stmt,2,SQLSRV_PHPTYPE_STREAM);

$photocod='';

while (!feof($photostream))

{

$photocod.=fread($photostream,8192);

}

$photobin=base64_decode($photocod);

header("Content-type:image/jpeg");

echo $photobin;

}


While this one doesn't:

$sql=" Select Top 1DOC_Type,DOC_Document from Document_lie

where Doc_Compteur =7418;

";

$stmt=sqlsrv_conn_execute($conn,$sql);

if ($stmt){

while ($result=sqlsrv_stmt_fetch_array($stmt, SQLSRV_FETCH_TYPE_ASSOC)){

$photocod=$result['DOC_Document'];

$photobin=base64_decode($result['DOC_Document']);

$typedocu=$result['DOC_Type'];

}

header("Content-type:image/jpeg");

echo $photobin;

}

In fact, if you look at $photocod, you see the problem easily: $photocod gets the good length (in my case 80734 bytes), but only the first 65535 bytes are correct. The rest is filled with garbage. Looks like a pointer problem.