INF: Finding Length of SQL IMAGE Fields While Using DB-Library

Last reviewed: April 25, 1997
Article ID: Q63605

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

SUMMARY

The following information discusses how to find the length of an IMAGE field using DB-Library (DB-Lib) or the datalength() function.

MORE INFORMATION

DB-Library does not support huge pointers; therefore, no single data block can be larger than 64K. For image data less than 64K, the DBDATLEN() command returns the correct size (if TEXTSIZE is set to 64K). Otherwise, a query to SQL Server using the datalength() function is the best method to use to retrieve this information. For example:

   select datalength(Imagecolum) from Imagetable where
   Fname = "MARTIAN.BMP"

The DBDATLEN() command returns the minimum of the actual data length of the image field or the TEXTSIZE as set by the SET TEXTSIZE command.

Additional query words: dblib Transact-SQL
Keywords : kbprg SSrvDB_Lib
Version : 4.2
Platform : OS/2

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.