[Libreoffice-bugs] [Bug 117435] Firebird: Migration: data type Image [ LONGVARBINARY ] is not being migrated properly

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Silvain Dupertuis from comment #7)
> I noted that after migration from HSQLBD, images were transferred to an
> Image [BLOB] type of field. Data was not lost, but images would not show up
> in forms.
> I found a workaround by copying the data into a new [BLOB] field (with a sql
> query UPDATE "photos_table" SET "Photo2" = "Photo") and it worked. The
> pictures appear using this new field.
> Then I did some copying of table and data to recover the same field name so
> that the form(s) would not need any change.

Have tried this. Table editor will try to change the field for BLOB every time
I am editing the table. Here I have to choose "No - don't change". But when
setting the new format for the image-field to BLOB[BLOB]-field the content will
be shown.

-- 
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/20190615/6e14de67/attachment-0001.html>