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 of images

3 posts in Migration Last posting was on 2001-04-09 14:08:19.0Z
Dhruv Kumar Posted on 2001-04-09 12:30:36.0Z
From: "Dhruv Kumar" <dkumar@yomailbox.com>
Subject: BCP of images
Date: Mon, 9 Apr 2001 08:30:36 -0400
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <Loua#QPwAHA.191@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
NNTP-Posting-Host: 209.208.136.90
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:246
Article PK: 1067670

What I've been trying these days is to BCP IN some images which are in jpeg
format in to a table which has image column in that. What's happening
basically is that am not getting any error after bcp in and I can see those
rows inserted in to my table as a result of bcp in. but when I do bcp out of
the same table I do get output file but file size is different from actual
jpeg file size and contants too. size is smaller then the actual file size.
If any one has any idea about this then would you like to suggest me some
thing how to do this.

Thanx in advance.

Dhruv


Michael Heaney Posted on 2001-04-09 12:55:31.0Z
Message-ID: <3AD1B143.7611C4B5@tigr.org>
Date: Mon, 09 Apr 2001 08:55:31 -0400
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 of images
References: <Loua#QPwAHA.191@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.migration
Lines: 20
NNTP-Posting-Host: janus.tigr.org 192.207.234.65
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:245
Article PK: 1067668


Dhruv Kumar wrote:
>
> What I've been trying these days is to BCP IN some images which are in jpeg
> format in to a table which has image column in that. What's happening
> basically is that am not getting any error after bcp in and I can see those
> rows inserted in to my table as a result of bcp in. but when I do bcp out of
> the same table I do get output file but file size is different from actual
> jpeg file size and contants too. size is smaller then the actual file size.
> If any one has any idea about this then would you like to suggest me some
> thing how to do this.
>

Two ideas:
1) Are you using the -T option with bcp?
2) Is there enough space in the directory to which you're writing the file?



Michael Heaney
TIGR


Dhruv Kumar Posted on 2001-04-09 14:08:19.0Z
From: "Dhruv Kumar" <dkumar@yomailbox.com>
References: <Loua#QPwAHA.191@forums.sybase.com> <3AD1B143.7611C4B5@tigr.org>
Subject: Re: BCP of images
Date: Mon, 9 Apr 2001 10:08:19 -0400
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <N9AilHQwAHA.259@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
NNTP-Posting-Host: 209.208.136.90
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:244
Article PK: 1067669

Would you please tell me what value should I put for -T if my file size is
6358KB.

Thanx
Dhruv

"Michael Heaney" <mheaney@tigr.org> wrote in message
news:3AD1B143.7611C4B5@tigr.org...
> Dhruv Kumar wrote:
> >
> > What I've been trying these days is to BCP IN some images which are in
jpeg
> > format in to a table which has image column in that. What's happening
> > basically is that am not getting any error after bcp in and I can see
those
> > rows inserted in to my table as a result of bcp in. but when I do bcp
out of
> > the same table I do get output file but file size is different from
actual
> > jpeg file size and contants too. size is smaller then the actual file
size.
> > If any one has any idea about this then would you like to suggest me
some
> > thing how to do this.
> >
>
>
> Two ideas:
> 1) Are you using the -T option with bcp?
> 2) Is there enough space in the directory to which you're writing the
file?
>
>
>
> Michael Heaney
> TIGR