KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: READ PICTURE FILE, BLOB TO PICTURE, and PICT images
PRODUCT: 4D | VERSION: 11.5 | PLATFORM: Mac & Win
Published On: January 15, 2010
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

For most picture files you use DOCUMENT TO BLOB to upload the picture file to your database. Then you can use BLOB TO PICTURE to store them in a picture variable.

As of 4D v11 SQL Release 5, the BLOB TO PICTURE command stores files of these types and codecs into picture variables:

ExtensionCodec Name
.4pct4PCT File
.jpgJPEG image
.pngPNG image
.bmpRLE File
.gifGIF image
.tifTIFF image
.emfEMF File (Windows only)
.pictPICT Image (do not use BLOB TO PICTURE)
.pdfEPS File
.svgSVG File
.sgiSGI Image
.psdPhotoshop Image
.pntgMacPaint Image
.targaTruevision TGA Image
.jp2JPEG 2000 Image
.qtifQuickTime Image


For images of the PICT Image codec (.pict files), use READ PICTURE FILE instead to properly read these files. This command allows you to open a picture saved in a file on fisk and load it directly into a 4D picture variable or field.