Hello,
PB 2019 R3, PostgreSQL 11
Got blob data in one of our tables where images are stored, which we are showing in two different ways. The output looks different in the display size. Why?
Left hand side: which is a picture column [ Insert -> Control -> Picture ]. Read the blob data using selectblob write to an external file, assign the pathname to the picture control.
Right hand size: Table blob column [ Insert -> Control -> Table Blob ].
The issue is size. The data stored in the blob is in 1170 x 1500 pixels. The width and height in the corresponding data window are the same. We tried resizing the width and height of the Table blob control. No change.
We are in the process of converting the picture control to Table blob control, to avoid storing the data (again) in an external file. Since it's a photo of students which, if resized, doesn't look good.
Is there any reason why it's gets resized when showing as Table blob control? Any solution?
Happiness Always
BKR Sivaprakash
Original size will span a almost a full A4 size. Table Blob control could be resized, but image displayed inside the control is not resizing.
Now there is sufficient space in the table blob control to display the image, which is not being utilized(?).
Any Modify command exists which will resize the image's size inside the control to fit to the size of the control ?
The other way around this that I have used in the past is to use the ImageMagicK (free open source tool) to introspect the image and then get it's size. From there, set the image's width & height from there.
Ideally though, the way forward could be to create an enhancement request for the TableBlob feature to allow "Original" size as a DWO property setting for this type of column data.