|
|
Unidentified images or binary data
When
you retrieve data from your database and SQL Image Viewer fails to
identify the type of data, but you know it is suppose to be a
specific type of data, you should perform the following:
|
·
|
select
the binary data and save it to disk. This saves the data as it is
stored in the database directly to a file.
|
|
·
|
rename
the file using the extension of the expected data type e.g. if it's
suppose to be a jpeg image file, rename the file using the .jpg
extension
|
|
·
|
try to
open the file using a common viewer e.g. for a jpeg image file,
Windows should be able to open the file using its built-in image
viewer
|
What we have encountered is that sometimes, applications that
support the storage of images sometimes compress the data prior to
saving it. The application may advertise the fact that it supports
the storage of x and y image types, but in reality, the data stored
in the database is in a different format.
|