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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue May 7 16:14:44 UTC 2019


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

--- Comment #7 from Silvain Dupertuis <silvain-dupertuis at bluewin.ch> ---
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.

-- 
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/20190507/e75be950/attachment.html>


More information about the Libreoffice-bugs mailing list