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

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 : kbtool SSrvBCP kbbug4.20
Version : 4.2 | 4.2 | 4.2
Platform : MS-DOS OS/2 WINDOWS
Issue type :


Last Reviewed: March 18, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.