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, you can use the following command to copy out all 40K:
bcp pubs2..publishers out -T40960
If a text or image field is larger than the given value or the default, bcp does not copy out the remaining data.