[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 #4 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Alex Thurgood from comment #3)
> Ah, my bad, perhaps, I saw you mention LO5.4 and assumed that these tests
> were done with a hsqldb ODB file instead of against Firebird. In that case,
> probably not relevant.

If I have it correctly, which I think I do, when 5.4 shipped the driver did not
support creating the type with the GUI controls, the backend (fb engine) did
but even that may of been an earlier version then the 3.0 used now. HSQL has no
problem with either embedded images or then MEMO(LONGVARCHAR with a length of
2gig) data types and the test file was firebird created with the later LO
version.

Firebird supports a varchar no longer than 32K bytes (with the number of
characters available for storage dependent on the number of bytes needed to
save a character for the selected character set). Does have a blob sub_type of
text and that is the CLOB(BLOB) type. That seems to work fine with the UI
controls in forms but not in ReportBuilder, but there is a workaround for
retrieving the first 32k bytes worth of text by casting the column to type
varchar in the result set fed to the report engine.

This issue with Image(BLOB) datatype and image controls would not be a
duplicate of that IMO.

-- 
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/20181205/8e05b772/attachment.html>