Tech Tip: READ PICTURE FILE, BLOB TO PICTURE, and PICT images
PRODUCT: 4D | VERSION: 11.5 | PLATFORM: Mac & Win
Published On: January 15, 2010
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:
| Extension | Codec Name |
| .4pct | 4PCT File |
| .jpg | JPEG image |
| .png | PNG image |
| .bmp | RLE File |
| .gif | GIF image |
| .tif | TIFF image |
| .emf | EMF File (Windows only) |
| .pict | PICT Image (do not use BLOB TO PICTURE) |
| EPS File | |
| .svg | SVG File |
| .sgi | SGI Image |
| .psd | Photoshop Image |
| .pntg | MacPaint Image |
| .targa | Truevision TGA Image |
| .jp2 | JPEG 2000 Image |
| .qtif | QuickTime 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.