Open any internal Firebird database. Open a table for editing or create a new table. There is a data type Binary(fix)[CHAR]. Choose this type for a field.
After saving the table open the table for data input. The field will get an <OBJECT>, so it couldn't be filled in the table view.
Create a form for it. I have tried many fields, also the image-control, which is the only field for read binary data. No possibility to get data into this field type.
Now reopen the table for editing. Look at the field. The type will have switched to Text(fix)[CHAR].
Don't know where Binary(fix)[CHAR] should be for. But a field, which couldn't be filled with content through a form or directly through the table view, should be removed from the table editor.
*** Bug 125958 has been marked as a duplicate of this bug. ***
Build ID: eda0568ec550a10b962c2427edfe05ea3197f107
CPU threads: 4; OS: Mac OS X 10.14.5; UI render: default; VCL: osx;
Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
On pc Debian x86-64 with master sources updated today, I could reproduce this.
This type has been added with this block:
865 // Binary (CHAR)
866 // It is distinguished from Text type by its character set
867 aRow = new ORowSetValueDecorator(OUString("CHAR"));
868 aRow = new ORowSetValueDecorator(DataType::BINARY);
869 aRow = new ORowSetValueDecorator(sal_Int16(32765)); // Prevision = max length
870 aRow = new ORowSetValueDecorator(OUString("length")); // Create Params
871 aRow = new ORowSetValueDecorator(
872 sal_Int16(ColumnSearch::NONE)); // Searchable
873 aRow = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
874 aRow = ODatabaseMetaDataResultSet::get0Value(); // Max scale
in commit https://cgit.freedesktop.org/libreoffice/core/commit/?id=bf662904c4b60e93c6b86e06288d41996eed12a2
author Tamas Bunth <email@example.com> 2017-12-16 12:57:43 +0100
committer Tamás Bunth <firstname.lastname@example.org> 2017-12-28 10:39:48 +0100
commit bf662904c4b60e93c6b86e06288d41996eed12a2 (patch)
parent 3c567e55e6aed9e0da892d8b9fc09f8a0c784fcc (diff)
tdf#104734 Firebird: Add Binary (fix) type
There is no explicit binary type in Firebird. It can be accomplished
using the CHAR type with a special character set, which tells the
database that it is binary data and there is no collation. (called
Because of that, we also need the character set to decide the exact
And also refactor some parts of the driver:
- Create class to determine internal type from firebird type, subtype,
scale and character set.
- Use internal type (DataType::XXX) in XDatabaseMetaData::getTypeInfo()
indirectly. (We want to return a Firebird type for each internal type,
not in the opposite direction.
I can remove the block but perhaps it should be fixed, in this case, I don't know what should be done.
Lionel/Tamas: don't hesitate to share your thoughts about it.