BUG: BCP Cannot Copy Text/Image Data > 64K from SQL Server

Last reviewed: April 29, 1997
Article ID: Q111921

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

BUG# 9827 (4.2)

SYMPTOMS

When using the BCP.EXE utility to extract data from a SQL Server, large text and image fields are truncated to 64 kilobytes.

CAUSE

BCP.EXE cannot extract more than the first 64K of data from a text or image field in a SQL Server table.

WORKAROUND

If performing a server to server data transfer to SQL Server for Windows NT, the SQL Transfer Manager can be successfully used to transfer large text or image fields. If exporting data to a flat file, it may be necessary to write a DB-Library (DB-Lib) program that makes use of the dbreadtext() function to extract large blocks of text and image data.

STATUS

Microsoft has confirmed this to be a problem in BCP version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: db-lib dblib bulk load import
Keywords : kbbug4.20 kbtool SSrvBCP
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 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.