Ask Your Question

How create Clob field in Design View in Base - Firebird?

asked 2019-05-13 14:34:18 +0100

Rolandvl gravatar image

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: (x64) on Windows10 with Firebird embed.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-05-13 19:00:49 +0100

Ratslinger gravatar image


There are still quite a few bugs regarding Firebird and you may want to examine those in Bugzilla.

Have tested your file using Mint 18.3 & LO v6.2.3.2 and your Table2. When adding a new field to the end got the warning message but selected NO & table seems to be OK:

image description

Also had no problems with creating new tables with CLOB or BLOB fields no matter where they were placed. This may be due to the version you have installed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2019-05-13 14:34:18 +0100

Seen: 140 times

Last updated: May 13