<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Migration: data type Image [ LONGVARBINARY ] is not being migrated properly" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117435#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Migration: data type Image [ LONGVARBINARY ] is not being migrated properly" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117435">bug 117435</a> from <a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> Robert Großkopf</a> <pre>(In reply to Silvain Dupertuis from <a href="show_bug.cgi?id=117435#c7">comment #7</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>