how can i read the <binary> in sql server

Can i read back the data'Please explain your question. Give an example of what you are trying to do.
--
David Portas
SQL Server MVP
--|||I have bought the application software which is linking with sql server 2000
from verndor
we can customize the software/table...
I saw one field which is set on<binary>
and we cannot see the data on that field...all data is <binary>
so i would like to ask can i read back the data?
thx
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ¦b¶l¥ó
news:7oydnU3XVb9xQp3cRVn-uQ@.giganews.com ¤¤¼¶¼g...
> Please explain your question. Give an example of what you are trying to
do.
> --
> David Portas
> SQL Server MVP
> --
>|||inamori,
Just issue a SELECT statement on the binary column.
create table bin (
i int not null primary key identity (1,1),
b binary (8) -- binary column
)
go
insert bin (b) select cast(0xFF as int)
select i,cast(b as int) mybin from bin
i mybin
-- --
1 255
(1 row(s) affected)
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
inamori wrote:
> I have bought the application software which is linking with sql server 2000
> from verndor
> we can customize the software/table...
> I saw one field which is set on<binary>
> and we cannot see the data on that field...all data is <binary>
> so i would like to ask can i read back the data?
> thx
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ¦b¶l¥ó
> news:7oydnU3XVb9xQp3cRVn-uQ@.giganews.com ¤¤¼¶¼g...
>>Please explain your question. Give an example of what you are trying to
> do.
>>--
>>David Portas
>>SQL Server MVP
>>--
>>
>
>|||sorry the data type is image......
"inamori" <test@.test.com> ¦b¶l¥ó news:cdr38s$lv22@.imsp212.netvigator.com ¤¤
¼¶¼g...
> I have bought the application software which is linking with sql server
2000
> from verndor
> we can customize the software/table...
> I saw one field which is set on<binary>
> and we cannot see the data on that field...all data is <binary>
> so i would like to ask can i read back the data?
> thx
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ¦b¶l¥ó
> news:7oydnU3XVb9xQp3cRVn-uQ@.giganews.com ¤¤¼¶¼g...
> > Please explain your question. Give an example of what you are trying to
> do.
> >
> > --
> > David Portas
> > SQL Server MVP
> > --
> >
> >
>|||inamori,
See this thread for some good information.
Subject: Re: How to Retrieve the Image stored in the DataBase
http://tinyurl.com/3k6pa
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
inamori wrote:
> sorry the data type is image......
> "inamori" <test@.test.com> ¦b¶l¥ó news:cdr38s$lv22@.imsp212.netvigator.com ¤¤
> ¼¶¼g...
>>I have bought the application software which is linking with sql server
> 2000
>>from verndor
>>we can customize the software/table...
>>I saw one field which is set on<binary>
>>and we cannot see the data on that field...all data is <binary>
>>so i would like to ask can i read back the data?
>>thx
>>"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ¦b¶l¥ó
>>news:7oydnU3XVb9xQp3cRVn-uQ@.giganews.com ¤¤¼¶¼g...
>>Please explain your question. Give an example of what you are trying to
>>do.
>>--
>>David Portas
>>SQL Server MVP
>>--
>>
>>
>|||Thanks
i got something at least
"0x640200005E414C4C"
can i change back to the meaningful data.....
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ?
news:OkE8BnLcEHA.1248@.TK2MSFTNGP11.phx.gbl ?...
> inamori,
> Just issue a SELECT statement on the binary column.
> create table bin (
> i int not null primary key identity (1,1),
> b binary (8) -- binary column
> )
> go
> insert bin (b) select cast(0xFF as int)
> select i,cast(b as int) mybin from bin
> i mybin
> -- --
> 1 255
> (1 row(s) affected)
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> inamori wrote:
> > I have bought the application software which is linking with sql server
2000
> > from verndor
> >
> > we can customize the software/table...
> >
> > I saw one field which is set on<binary>
> >
> > and we cannot see the data on that field...all data is <binary>
> >
> > so i would like to ask can i read back the data?
> >
> > thx
> > "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ¦b¶l¥ó
> > news:7oydnU3XVb9xQp3cRVn-uQ@.giganews.com ¤¤¼¶¼g...
> >
> >>Please explain your question. Give an example of what you are trying to
> >
> > do.
> >
> >>--
> >>David Portas
> >>SQL Server MVP
> >>--
> >>
> >>
> >
> >
> >|||Depends. Do you know what format the data is in? You'll probably need to do
this in a client application. For example if it contains a graphics file or
Word document then you'll need to open that in something that can interpret
the format.
--
David Portas
SQL Server MVP
--