[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 #9 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Julien Nabet from comment #8)
> (In reply to Lionel Elie Mamane from comment #7)
> Remark I suppose the last one is:
> > and replace
> >          case DataType::BLOB:
> >             return "BLOB";
> > by
> >          case DataType::BLOB:
> >             return "BLOB SUBTYPE BINARY";

Yes.

> Anyway, it'll work for this case but it'll regress for "tdf#137801"
> since I got:
> sTypeName=SMALLINT pField->GetTypeName()=BLOB SUBTYPE BINARY

Sorry, the correct token is SUB_TYPE, not SUBTYPE. Replace everywhere. See
https://firebirdsql.org/file/documentation/pdf/en/refdocs/fblangref25/firebird-25-language-reference.pdf
section 3.6 page 38.

-- 
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/20201030/61494b09/attachment.htm>