Bug #1525: It's not possible to receive from MSSQL TEXT field more than 4K data
| From: | vin at dor dot ru | Date: | Fri, 11 Jun 1999 03:44:05 +0000 |
| Subject: | Bug #1525: It's not possible to receive from MSSQL TEXT field more than 4K data | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-6814@lists.php.net to get a copy of this message | ||
From: vin@dor.ru
Operating system: Windows NT 4.0
PHP version: 3.0.8
PHP Bug Type: MSSQL related
Bug description: It's not possible to receive from MSSQL TEXT field more than 4K data
SET TEXTSIZE XXXX does change result dataset length but only
in less than 4K range
e.g.
function Get_Text_Field ( $Conn, $Doc_ID ) {
$sql = "SET TEXTSIZE 65000";
if( ! $RS = mssql_query( $sql, $Conn ) ) {
return ;
}
$sql = "SELECT TextField FROM Doc WHERE Doc_ID=$Doc_ID";
if( ! $RS = mssql_query( $sql, $Conn ) ) {
return ;
}
if ($Result = mssql_fetch_object($RS))
return $Result;
else {
return ;
}
}