Firebird 4 Release

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
leonardt.neugebauer
Posts: 32
Joined: Wed 27 May 2020 06:22

Firebird 4 Release

Post by leonardt.neugebauer » Tue 02 Feb 2021 09:38

Hello,

the first release version of Firebird 4 was published on 01.02.2021.
When can we expect UniDac support for Firebird 4?
So that we can also test Firebird 4 in interaction with our applications and UniDac.

First point, would be in any case the support for the new data types.
Without the support we can't even start our application, because we access some MON$ and RDB$ system tables and under Firebird 4 they already have the timestamp fields set to "TIMESTAMP WITH TIME ZONE".

https://firebirdsql.org/en/news/firebir ... r-testing/

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Firebird 4 Release

Post by oleg0k » Tue 02 Feb 2021 12:30

Hello,
We support only the release versions of DBMS since beta versions or release candidates may contain errors, and the release version may differ a lot from the beta version or release candidate. Therefore, we will add support for Firebird 4 when it is officially released.

wbr, Oleg
Devart Team

leonardt.neugebauer
Posts: 32
Joined: Wed 27 May 2020 06:22

Re: Firebird 4 Release

Post by leonardt.neugebauer » Thu 22 Apr 2021 08:41

Hello,

for all who already want to test Firebird 4.
In the firebird.conf you can specify DataTypeCompatibility. This will disable the new data types from Firebird 4, so you can use Firebird 4 with Unidac.
6. Application level incompatibilities
Firebird 4 client library "fbclient" is compatible with previous versions at API level. But there may be compatibility problems for some SQL queries. Some of them were described above. Next is information about other incompatibilities.
6.1. New data types
Some expressions can return new data types that your application cannot process without its modification. This modification may take too much time, or will require changing the code of the data access components, etc. To simplify migration to new versions, you can set the DataTypeCompatibility parameter to the compatibility mode with the required version in firebird.conf or databases.conf.

DataTypeCompatibility = 3.0

This is the fastest way to get compatibility with new data types. During time you may add new data types support to your applications. Since it will happen gradually, one datatype first, then another, etc, you may set data type binding of the types that your applications still do not support.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Firebird 4 Release

Post by ViktorV » Wed 22 Sep 2021 16:38

Hi Leonard!

Please note that we have already released UniDAC 9.0.1 and IBDAC 8.0.1 with Firebird 4 support: we supported INT128, DECFLOAT and large NUMERIC types, as well as table names up to 64 characters.
The TIMESTAMP WITH TIME ZONE type is supported as a string in this release.
The full support of this type will be in the next release of IBDAC!
Should you have any questions, do not hesitate to ask!

Best regards,
Viktor

FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

Re: Firebird 4 Release

Post by FredS » Fri 24 Sep 2021 18:54

leonardt.neugebauer wrote: Thu 22 Apr 2021 08:41 so you can use Firebird 4 with Unidac.
Thanks, and FYI: connecting with fbclient (v3.07) to a v4 server does all that already..

Post Reply