Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

BCP and TEXTSIZE

2 posts in Backup and Recovery Last posting was on 2001-02-21 18:50:31.0Z
javapro Posted on 2001-02-21 16:12:21.0Z
From: javapro
Date: Wed, 21 Feb 2001 11:12:21 -0500
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: BCP and TEXTSIZE
Message-ID: <DC926F545192EB7B005905A5852569FA.0059057D852569FA@webforums>
Lines: 13
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:488
Article PK: 1061001

Hi,

I am trying to use BCP out on a table that contains an image
column. The problem is the output file contains only part of the
image - up to the size of the TEXTSIZE setting, which is set at 32768.

How do I set the textsize with BCP to allow for output of the
entire image column? There is no BCP command line option to
do this.

Thanks!

-javapro


Michael Heaney Posted on 2001-02-21 18:50:31.0Z
Message-ID: <3A940DF7.A5E6A67B@tigr.org>
Date: Wed, 21 Feb 2001 13:50:31 -0500
From: Michael Heaney <mheaney@tigr.org>
Organization: The Institute for Genomic Research
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: BCP and TEXTSIZE
References: <DC926F545192EB7B005905A5852569FA.0059057D852569FA@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 26
NNTP-Posting-Host: janus.tigr.org 198.76.161.65
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:487
Article PK: 1060990


javapro wrote:
>
> Hi,
>
> I am trying to use BCP out on a table that contains an image
> column. The problem is the output file contains only part of the
> image - up to the size of the TEXTSIZE setting, which is set at 32768.
>
> How do I set the textsize with BCP to allow for output of the
> entire image column? There is no BCP command line option to
> do this.

Use the -T option to specify a larger size for text/image fields.
I typically set mine to 10 million bytes, like so:

bcp mydb..mytab out mytab.bcp -T10000000 ...



--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Michael Heaney Email: mheaney@tigr.org
Database Manager Phone: (301) 838-3553
The Institute for Genomic Research FAX: (301) 838-0208
9712 Medical Center Drive
Rockville, MD 20850
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

"Aside from that, Mrs. Lincoln, how did you enjoy the play?"