<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - LO Base Report Builder Does Not Display CLOB (memo field) Data of External HSQLDB and Firebird (embedded / file)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=115893#c18">Comment # 18</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - LO Base Report Builder Does Not Display CLOB (memo field) Data of External HSQLDB and Firebird (embedded / file)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=115893">bug 115893</a>
from <span class="vcard"><a class="email" href="mailto:trowelandmattock@yahoo.co.uk" title="trowelandmattock@yahoo.co.uk">trowelandmattock@yahoo.co.uk</a>
</span></b>
<pre>There appears to be no fix for this yet, making design/modification of
databases with data difficult for CLOB types, and especially difficult for
migration to firebird with existing database structures.
Here is my work-around for changing a field to CLOB in existing table with
data:
1: create the new intended CLOB field as VarChar
2: copy the table and data to a spreadsheet
3:copy the spreadsheet
4: paste back into base as new table, and use the dialog to change the VarChar
to CLOB as needed - no other method appears to work :/
NB//
The first attempt may not get all the data copied, AND might rearrange some
columns (!!!)
Fix this by creating new firebird DB (for safety) - then copy original table
there, making sure to use initial dialog to set CLOB - proceed through the many
dialog boxes... (errors and all!) - now delete all the spurious data just
leaving the definitions - note if any column order has changed - now copy the
original data to a spreadsheet, and modify to match any changed columns in new
version - now copy spreadsheet and append to the new table - check it again as
the first row seems to get buggy, but all the other data should be there
...sigh.
Love You Libre! (firebird don't us down now please:)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>