Since this is varbinary, the trailing eroes are suppressed by default --
they haven't not disappeared but they're just not displayed. In other words,
it's a formatting issue. Try doing a convert to binary(255) and you'll see
what I mean...

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"FCA" <marakaimbo@libero.it> wrote in message
news:c4ug4u$2nanlk$1@ID-110320.news.uni-berlin.de...
> Tahnk yuo "Carl Kayser"
>
> But this is not my problem.
> My problem is that, when I try to insert a virbinary that have last byte
to
> 00 i have this situation:
>
> insert into my_table select 0x0400010000
> go
>
> select * from my_table
> go
>
> my_field
> ---------
> 0x040001
>
> where is 0000?
>
>
>
> "Carl Kayser" <kayser_c@bls.gov> wrote in message
> news:c4uajp$ats$1@blsnews.bls.gov...
> >
> > select bintostr (my_field) from ... may solve your problem. I'm not
sure
> > as to when this function became available.
> >
> >
> > "FCA" <marakaimbo@libero.it> wrote in message
> > news:c4u5jc$2l1cr2$1@ID-110320.news.uni-berlin.de...
> > > Version: Sybase 12.5.1
> > > I have a table with a varbinary(255) field.
> > >
> > > When i try to insert this varbinary "0x0400010000" in my table, i can
> see
> > > thet last two bytes are inesistent.
> > >
> > > select my_field from my tables
> > > go
> > >
> > >
> > > I have this output:
> > > 0x040001
> > >
> > > Why???How can i solve this problem???
> > > Thanks in Advance.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>