I created an embedded Firebird-database.
I 'll try to create a table (TABLE1) in Design View a field COMMENT with a CLOB-field type. When I click on save, the field type changes from CLOB[BLOB] to BLOB[BLOB]. When I re-open for editing this table TABLE1, I see there on the field type BLOB[BLOB]. The field COMMENT is the last field in the table.
What is now the actual field type of COMMENT?
This behavior is different when the last field is not a CLOB. See TABLE2, there is in Field Type CLOB[BLOB] for COMMENT.
The problem is when you want to add a field, and save the table, you get "The column “COMMENT” could not be changed. ". But I have not touched it? I cannot anymore change that TABLE2
My questions is now:
What are the actual field types of COMMENT in the 2 tables?
How to use Table Designer with CLOB-fields?
LibreOffice Version: 184.108.40.206 (x64) on Windows10 with Firebird embed.