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.

varbinary datatype and truncation

4 posts in Windows NT Last posting was on 2000-06-14 18:30:06.0Z
Ted Pietrzak Posted on 2000-06-09 23:18:15.0Z
From: "Ted Pietrzak" <tedp@globeset.com>
Subject: varbinary datatype and truncation
Date: Fri, 9 Jun 2000 18:18:15 -0500
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <OuH9jom0$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: con.globeset.com 216.141.188.121
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2048
Article PK: 1089505

According to the Sybase manuals, varbinary columns will truncate trailing
NULL values at insertion
time. So, for instance, if I insert 0x0459af8800, I will receive back
0x0459af88 when I retreive the
data element. Is there a configuration option that will disable this
"feature" and allow me to get back the
data exactly as I inserted it?

Regards,
Ted Pietrzak


Tommy Phillips Posted on 2000-06-12 19:15:49.0Z
Message-ID: <394536E5.6CC5F8C8@sybase.com>
Date: Mon, 12 Jun 2000 13:15:49 -0600
From: Tommy Phillips <tommy@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.73 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: varbinary datatype and truncation
References: <OuH9jom0$GA.203@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------055141B67BEC8EB71EA182B1"
Newsgroups: sybase.public.sqlserver.nt
Lines: 30
NNTP-Posting-Host: tommy-lpt.sybase.com 157.133.56.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2041
Article PK: 1089496

nope

Ted Pietrzak wrote:
>
> According to the Sybase manuals, varbinary columns will truncate trailing
> NULL values at insertion
> time. So, for instance, if I insert 0x0459af8800, I will receive back
> 0x0459af88 when I retreive the
> data element. Is there a configuration option that will disable this
> "feature" and allow me to get back the
> data exactly as I inserted it?
>
> Regards,
> Ted Pietrzak


Download VCard tommy.vcf


Ted Pietrzak Posted on 2000-06-13 19:00:04.0Z
From: "Ted Pietrzak" <tedp@globeset.com>
References: <OuH9jom0$GA.203@forums.sybase.com> <394536E5.6CC5F8C8@sybase.com>
Subject: Re: varbinary datatype and truncation
Date: Tue, 13 Jun 2000 14:00:04 -0500
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <zyAMBrW1$GA.315@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: con.globeset.com 216.141.188.121
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2032
Article PK: 1089492

Thanks for the confirmation. Ought of curiosity, do you have any idea of
what the rationale was
behind this? It sure seems like surprising behaviour and it's not mirrored
by Microsoft SQL
Server. Given the shared heritage, I would have expected both products to
exhibit the same
behavior.

Ted

"Tommy Phillips" <tommy@sybase.com> wrote in message
news:394536E5.6CC5F8C8@sybase.com...
> nope
>
> Ted Pietrzak wrote:
> >
> > According to the Sybase manuals, varbinary columns will truncate
trailing
> > NULL values at insertion
> > time. So, for instance, if I insert 0x0459af8800, I will receive back
> > 0x0459af88 when I retreive the
> > data element. Is there a configuration option that will disable this
> > "feature" and allow me to get back the
> > data exactly as I inserted it?
> >
> > Regards,
> > Ted Pietrzak


Tommy Phillips Posted on 2000-06-14 18:30:06.0Z
Message-ID: <3947CF2E.2352E2D3@sybase.com>
Date: Wed, 14 Jun 2000 12:30:06 -0600
From: Tommy Phillips <tommy@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.73 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: varbinary datatype and truncation
References: <OuH9jom0$GA.203@forums.sybase.com> <394536E5.6CC5F8C8@sybase.com> <zyAMBrW1$GA.315@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------84394FAFD53938FE215F9C09"
Newsgroups: sybase.public.sqlserver.nt
Lines: 29
NNTP-Posting-Host: tommy-lpt.sybase.com 157.133.56.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2028
Article PK: 1089486

I agree that it is non-intuitive. I refuse to speculate what trade-offs or pressures caused the decision to incorporate this bevavior back in the dark ages.

Ted Pietrzak wrote:
>
> Thanks for the confirmation. Ought of curiosity, do you have any idea of
> what the rationale was
> behind this? It sure seems like surprising behaviour

<snip>


Download VCard tommy.vcf