|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-01-12 07:01 UTC] sniper@php.net
[2004-01-12 08:19 UTC] agnerm at aloc dot dk
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Nov 05 17:00:02 2025 UTC |
Description: ------------ When trying to get a IMAGE-field from a MSSQL database I only get the first 4096. Reproduce code: --------------- function SQL($sqlStatement) { global $sqlConnection,$sqlDB; mssql_select_db($sqlDB,$sqlConnection) or die("fejl ved \"connection\" til databasen ($sqlDB)"); $rs = mssql_query($sqlStatement,$sqlConnection) or die("Fejl i Sql-".nl2br($sqlStatement)); return $rs; } function SQL2D($sqlStatement,$antal=-1) { global $sqlConnection,$sqlDB; $dataArray=""; $rs=SQL($sqlStatement,$sqlDB); if (mssql_num_rows($rs)==0) return null; if ($antal==-1) $antal=mssql_num_rows($rs); for ($y=0;(($y<mssql_num_rows($rs))&&($y<$antal));$y++) { $row = mssql_fetch_row($rs); for($i=0;$i<count($row);$i++) { $dataArray[$y][mssql_field_name($rs,$i)]=$row[$i]; } } return $dataArray; } SQL("SET TEXTSIZE 512000"); SQL2D_out("SELECT @@TEXTSIZE"); $fil=SQL2D("SELECT len= DATALENGTH(dbo.nyheder.fil),dbo.nyheder.fil from dbo.nyheder where nyhederid=9"); echo $fil[0]["len"]; echo "\n<br>"; echo strlen ($fil[0]["fil"]); Expected result: ---------------- <table border=1> <tr> <td>computed</td> </tr> <tr> <td>512000</td> </tr> </table> 34510 <br>34510 Actual result: -------------- <table border=1> <tr> <td>computed</td> </tr> <tr> <td>512000</td> </tr> </table> 34510 <br>4096