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.
> >
> >
> >
> >
> >
> >
> >
>
>