[Libreoffice-bugs] [Bug 121553] Editing: Firebird: Table editor erroneously prompts to change CLOB field to a BLOB field during alter table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121553

--- Comment #3 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Real type.

BLOB and CLOB are two types of LOB, to be AR about it.

>From Firebird perspective a CLOB is a specialized sub type of BLOB with the C
in CLOB standing for Character and the BLOB being a generic binary encoded
large object. CLOB signifies to client software that the binary data may be
retrieved as character data. 

Same is true of the Image field type in Base, which is another BLOB sub type.

So, it is accurate in the table editor to, as it does, display the types as:
BLOB  [BLOB]
CLOB  [BLOB]
IMAGE [BLOB]

The actual equivalent to the CLOB [BLOB] field in the HSQLdb SDBC was the field
type MEMO [BLOB].

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181120/96b2cc26/attachment-0001.html>