<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Datatype Image(BLOB) is not working properly with Form or Report image controls." href="https://bugs.documentfoundation.org/show_bug.cgi?id=121886#c12">Comment # 12</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Datatype Image(BLOB) is not working properly with Form or Report image controls." href="https://bugs.documentfoundation.org/show_bug.cgi?id=121886">bug 121886</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>(In reply to Robert Großkopf from <a href="show_bug.cgi?id=121886#c11">comment #11</a>) > Images are only shown in the control with BLOB[BLOB]-fields, not with > Image[BLOB] fields. It's the same reason as for <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Migration: data type Image [ LONGVARBINARY ] is not being migrated properly" href="show_bug.cgi?id=117435">bug 117435</a>. 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>