PRB: Maximum TEXTSIZE in SAF and ISQL

Last reviewed: April 25, 1997
Article ID: Q70867

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

SYMPTOMS

Trying to increase the amount of text returned by SAF or ISQL to more than 4K using the SET TEXTSIZE statement does not work.

CAUSE

Using the SET TEXTSIZE command with any value greater than 4096 has no effect on the actual amount of text that is returned from a SELECT statement issued through SAF or ISQL. Although the syntax allows you to set the TEXTSIZE value to be greater than 4K, the actual maximum that this can be set to in SAF and ISQL is 4K. You can, however, use the SET TEXTSIZE statement to set the TEXTSIZE to a value smaller than 4K.

WORKAROUND

Note that this is not an issue in a DB-Library (DB-Lib) application. If you are writing an application that will select data from a column with text datatype, by default you will only get the first 4K of data back. However, this can be changed by using the DBTEXTLIMIT and DBTEXTSIZE options.

Additional query words: SAF ISQL TEXTSIZE data type
TEXTLIMIT dblib Windows NT
Keywords : kbtool SSrvGen SSrvISQL SSrvWinNT
Version : 4.2 | 4.2 | 4.2
Platform : MS-DOS OS/2 WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.