|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[1999-06-10 23:44 UTC] vin at dor dot ru
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 ;
}
}
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2023 The PHP GroupAll rights reserved. |
Last updated: Sat Sep 30 01:01:24 2023 UTC |
you can set the following php3.ini options: mssql.textsize = 8192 mssql.textlimit = 8192 textlimit can be anything from 0 to text limit and textsize can be anything from 0 to 2Gb. From the MS SQL Server docs: SET TEXTSIZE (T-SQL) Specifies the size of text and ntext data returned with a SELECT statement. Syntax SET TEXTSIZE {number | @number_var} Arguments number | @number_var Is the size (an integer) of text data, in bytes. The maximum setting for SET TEXTSIZE is 2 gigabytes (GB), specified in bytes. A setting of 0 resets the size to the default (4 KB). Remarks Setting SET TEXTSIZE affects the @@TEXTSIZE function. The DB-Library variable DBTEXTLIMIT also limits the size of text data returned with a SELECT statement. If DBTEXTLIMIT is set to a smaller size than TEXTSIZE, only the amount specified by DBTEXTLIMIT is returned. For more information, see Programming DB-Library for C. The SQL Server ODBC driver and Microsoft OLE DB Provider for SQL Server automatically set TEXTSIZE to 2147483647 when connecting. The setting of set TEXTSIZE is set at execute or run time and not at parse time. Permissions SET TEXTSIZE permissions default to all users.