Wednesday, March 28, 2012

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> bl
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> bl
> news:7oydnU3XVb9xQp3cRVn-uQ@.giganews.com g...
>
> do.
>
>
|||sorry the data type is image......
"inamori" <test@.test.com> bl 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> bl
> news:7oydnU3XVb9xQp3cRVn-uQ@.giganews.com g...
> do.
>
|||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> bl news:cdr38s$lv22@.imsp212.netvigator.com
> g...
>
> 2000
>
>
|||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 ?...[vbcol=seagreen]
> 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:
2000[vbcol=seagreen]
|||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
sql

No comments:

Post a Comment