https://bugs.documentfoundation.org/show_bug.cgi?id=104734
Bug ID: 104734
Summary: FIREBIRD: Add those field types that are not available
with FB while they are available with Hsqldb
Product: LibreOffice
Version: 5.4.0.0.alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Recently with #103074 fixed, BOOLEAN type was added to Firebird, but several
field types are not available with Firebird while they are with Hsqldb.
Name Hsqldb Firebird
Tiny Integer TINYINT (1) SMALLINT
BigInt BIGINT BIGINT
Image LONGVARBINARY (1) BLOB
Binary VARBINARY (1) BLOB
Binary (fix) BINARY (1) BLOB
Memo LONGVARCHAR (1) BLOB
Text (fix) CHAR CHAR
Number NUMERIC NUMERIC
Decimal DECIMAL DECIMAL
Integer INTEGER INTEGER
Small Integer SMALLINT SMALLINT
Float FLOAT FLOAT
Real REAL (1) DOUBLE PRECISION
Double DOUBLE DOUBLE PRECISION
Text VARCHAR VARCHAR
Text VARCHAR_IGNORECASE VARCHAR (2)
Yes/No BOOLEAN BOOLEAN
Date DATE DATE
Time TIME TIME
Date/Time TIMESTAMP TIMESTAMP
OTHER OTHER (1) BLOB
BLOB -- BLOB
(1) Not defined for FB in base, substitute types to use with FB
(2) Looks it can be achivied by defining a specific Collation for the column.
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes-chartypes.html#fblangref25-datatypes-chartypes-collation";
Actual Results:
Not all field's tupe defined for FB.
Expected Results:
Make easier to transpose a database with the embedded Hsqldb to Firebird
dragging the tables, without need to reenter the column definition.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101
Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
