<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#c7">Comment # 7</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:silvain-dupertuis@bluewin.ch" title="Silvain Dupertuis <silvain-dupertuis@bluewin.ch>"> Silvain Dupertuis</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>