Image Data Type

In one of the table I have a column"XMLCompressed" with Image data type. I
don't know which type of file it is. I have tried with .xml, .svg, .jpeg etc
.
Is there any way to see what is stored inside that columnHi
Data is stored in binary format
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Snehal" wrote:

> In one of the table I have a column"XMLCompressed" with Image data type. I
> don't know which type of file it is. I have tried with .xml, .svg, .jpeg e
tc.
> Is there any way to see what is stored inside that column|||I don't want data in binary format. It should be in some understandable form
at
"Chandra" wrote:
> Hi
> Data is stored in binary format
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Snehal" wrote:
>|||To SQL Server, data stored with the image datatype is pure binary data. SQL
Server doesn't care what
you put in there, and SQL server doesn't know what format you have in there.
I.e., there's no help
for SQL Server to be expected to understand the format of the data. Consider
having another column
in the table where you specify which format you have for each row (assuming
you have different
formats for different rows).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Snehal" <Snehal@.discussions.microsoft.com> wrote in message
news:92F5954C-728E-4B8B-B45F-4F3FEEE93AE5@.microsoft.com...
>I don't want data in binary format. It should be in some understandable for
mat
> "Chandra" wrote:
>|||Yes I aggree. But what different formats it can have? I just want to see the
contents of image data column. As the name of the column "xmlCompressed"
suggest it may have XML doc in it.
"Tibor Karaszi" wrote:

> To SQL Server, data stored with the image datatype is pure binary data. SQ
L Server doesn't care what
> you put in there, and SQL server doesn't know what format you have in ther
e. I.e., there's no help
> for SQL Server to be expected to understand the format of the data. Consid
er having another column
> in the table where you specify which format you have for each row (assumin
g you have different
> formats for different rows).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Snehal" <Snehal@.discussions.microsoft.com> wrote in message
> news:92F5954C-728E-4B8B-B45F-4F3FEEE93AE5@.microsoft.com...
>
>|||Hi,
You can use image field in sql server as data type field , but I have
another approach to save your data and to be viewable by using ole control
from vb 6 (toolbox) or unbound-bound control in MSACCESS , and later you can
insert object and select as paintbrush object , so you can view this data by
screen or by report.
NB1 : Ole control dropped from VS 2005 (so be careful when you use this
approach)
NB2: Database will upsize quickly.
Thanks,
Tarek Ghazali
"Snehal" <Snehal@.discussions.microsoft.com> wrote in message
news:D92F9D18-088F-41C8-9B54-BBBADB65A10F@.microsoft.com...
> In one of the table I have a column"XMLCompressed" with Image data type. I
> don't know which type of file it is. I have tried with .xml, .svg, .jpeg
> etc.
> Is there any way to see what is stored inside that column|||I adjusted my title (Email from) instead of Microsoft news it's Tarek
Ghazali right now.
Hi,
You can use image field in sql server as data type field , but I have
another approach to save your data and to be viewable by using ole control
from vb 6 (toolbox) or unbound-bound control in MSACCESS , and later you can
insert object and select as paintbrush object , so you can view this data by
screen or by report.
NB1 : Ole control dropped from VS 2005 (so be careful when you use this
approach)
NB2: Database will upsize quickly.
Thanks,
Tarek Ghazali
"Snehal" <Snehal@.discussions.microsoft.com> wrote in message
news:D92F9D18-088F-41C8-9B54-BBBADB65A10F@.microsoft.com...
> In one of the table I have a column"XMLCompressed" with Image data type. I
> don't know which type of file it is. I have tried with .xml, .svg, .jpeg
> etc.
> Is there any way to see what is stored inside that column|||> But what different formats it can have?
The person to ask this is the one who designed the table. Nobody else will k
now (for sure). We can
guess:
XML then zipped
XML then compressed to other standard formats
XML then compressed with some own compression algorithm
XML stored in a compressed format, defined by a standard body
I'd start with the last one. I did a Google on XML compressed and found hits
. I'd check first if
there is an accepted standard for storing XML data in a compressed format.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Snehal" <Snehal@.discussions.microsoft.com> wrote in message
news:D92B416E-1BA3-4682-B822-2A726DAE4085@.microsoft.com...
> Yes I aggree. But what different formats it can have? I just want to see t
he
> contents of image data column. As the name of the column "xmlCompressed"
> suggest it may have XML doc in it.
> "Tibor Karaszi" wrote:
>|||Thanks.
It will realy help me to move ahead.
Will you please ellobarate how to proceed with the guesses? I am also trying
to break as the person who designed the table is not available for my compan
y
right now.
"Tibor Karaszi" wrote:

> The person to ask this is the one who designed the table. Nobody else will
know (for sure). We can
> guess:
> XML then zipped
> XML then compressed to other standard formats
> XML then compressed with some own compression algorithm
> XML stored in a compressed format, defined by a standard body
> I'd start with the last one. I did a Google on XML compressed and found hi
ts. I'd check first if
> there is an accepted standard for storing XML data in a compressed format.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Snehal" <Snehal@.discussions.microsoft.com> wrote in message
> news:D92B416E-1BA3-4682-B822-2A726DAE4085@.microsoft.com...
>
>