[Libreoffice-bugs] [Bug 121886] Firebird: Datatype Image(BLOB) is not working properly with Form or Report image controls.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121886

--- Comment #12 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Robert Großkopf from comment #11)
> Images are only shown in the control with BLOB[BLOB]-fields, not with
> Image[BLOB] fields. It's the same reason as for bug 117435. Doesn't know why
> there is a field Image[BLOB] at all. Should be removed and the trouble will
> go away for these two bugs.

There is an Image[Blob] data type because for modern RDBMSs there are at least
3 types of blobs; basic binary, subtype image, subtype text.

Base being a front end tool and not a database per se (ODF spec) should
recognize the three different types and work with them appropriately.

With HSQLdb embedded for example the three blob subtypes are represented as
Image(Blob), Memo(Text) and Other.

With the Firebird embedded they are Blob[Blob], Image[Blob] and CLOB[Blob]. 

Images[Blob] is not being properly handled by the sdbc driver as evidenced in
the forms and reportbuilder problems.

For that matter Clob is also not handled properly by forms, and will not allow
the report wizard to finish if the user tries to insert an Clob field on a
form. Reportbuilder also fails to recoginize it.

Clob data types are also not being handled therefore properly by the sdbc code.

Also, using Blob[Blob] datatype for image data, with the 6.3 firebird sdbc
allow images to be used and displayed in forms but does nothing to help with
Reportbuilder. The reportbuilder code will add any Blob[Blob] field as a
Formatted Field in the form, not an image to be displayed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190616/657458d1/attachment.html>