Copy Out and Text and Image Data

When you copy out text or image data, Adaptive Server, by default, copies only the first 32K of data in a text or image field.

The -T text_or_image_size parameter allows you to specify a different value. For example, if the text field to copy out contains up to 40K of data, use the following command to copy out all 40K:

bcp pubs2..publishers out -T40960
Note: If a text or image field is larger than the given value or the default, bcp does not copy out the remaining data.
Parent topic: Transferring Data to and from Adaptive Server with bcp