CONTACT US
568-3-53 (3rd Floor), Kompleks Mutiara, 3 1/2 Mile, Jalan Ipoh
51200 Kuala Lumpur, Malaysia
6012 9714904
support@yohz.com
https://www.yohz.com
Copyright © 2005 - 2023 Yohz Software,
a division of Yohz Ventures Sdn Bhd.
ALL RIGHTS RESERVED.
All trademarks or registered trademarks are property of their respective owners
View and export images and files from
your databases using
SQL Image Viewer
•
identifies images and file types automatically
•
identify images and files stored in OLE Object columns
•
export embedded images to Excel spreadsheets
•
supports Access, MySQL, MariaDB, Oracle, PostgreSQL,
SQL Server, SQL Server Compact, SQLite, and ODBC
data sources
How to view images stored in your
database
Start SQL Image Viewer and connect to your database. For
SQL Server databases, tables containing blob columns will be
highlighted in green in the list of database objects. Write the
query to retrieve your images, and execute the query.
SQL Image Viewer will then display the result set, together
with any images it finds in the blob column(s).
Note that you did not need to specify the type of image stored
in the column. In this example, we only selected the blob
column, and SQL Image Viewer was able to automatically
determine the image format and also display the image
details.
If you prefer, you can choose to display only the image details
in the data set.
SQL Image Viewer supports the following image formats:
•
BMP
•
GIF (Graphic Interchange Format, static and animated)
•
JPEG
•
PNG (Portable Network Graphics)
•
PSD (Photoshop)
•
TIFF (Tagged Image File Format, single and multi page)
•
DICOM
Your query can be as complex as you need it to be, and can
return more than one blob column for each row. E.g.