Ask Your Question

firebird migration data type inconsistency

asked 2019-10-27 10:43:29 +0100

Ubiquity gravatar image

The second table of Data Types in the Firebird Migration Documentation seems to suggest that both Firebird and HSQLDB support Memo (longvarchar) datatypes whereas the first table showing migrated data types shows Memo will be converted to CLOB [ BLOB ] SUB_TYPE TEXT. Additionally when selecting field types for table fields using Create Table in Design View, if one chooses CLOB there is no indication of which sub-type will be used.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-10-27 21:30:58 +0100

Ratslinger gravatar image


In testing different field types within Firebird embedded, is appears there is no distinction on sub types. In fact when a field was set as CLOB in table design it was changed to BLOB[BLOB]. Image[BLOB], BLOB[BLOB] and CLOB[BLOB] all resulted with a field type of BLOB SUB_TYPE 0.

You can check with SQL found here -> How can I get the table description (fields and types) from Firebird with dbExpress .

Firebird server does show different sub types.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-27 10:43:29 +0100

Seen: 113 times

Last updated: Oct 27 '19