从数据库读取二进制图片显示问题

Question

<?php
$conn=mssql_connect("192.168.1.70","XXX","123") or die("数据库打开出错");
mssql_select_db("XXX");
mssql_query("set names utf8");$sql = "SELECT top 1 * FROM sync_info_BlogPic";$result2=mssql_query($sql);
header("Content-Type: image/jpg");
$row2=mssql_fetch_object($result2);echo $row2->BlogPic_Content;error:Image corrupt or truncated

Answer 1

字段IMAGE类型,存是ASP程序跑的.

Answer 2

php 提供给 mssql 的缓冲区可能偏小了

Answer 3

php.ini[MSSQL]
; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textlimit = 4096; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textsize = 4096