Firebird 4 Compatibility

[arvanus]

Firebird 4 has new datatypes, that currently IBPP has no support yet, then for you that are trying Firebird 4, I recommend this change at firebird.conf

DataTypeCompatibility = 3.0

You can use Fb4 without losses while you dont use this new datatypes

From the Firebird 4 firebird.conf file, you can read this:

# ----------------------------
# Engine currently provides a number of new datatypes unknown to legacy clients.
# In order to simplify use of old applications set this parameter to minor FB
# version datatype compatibility with which you need. Currently two values are
# supported: 3.0 & 2.5.
# More precise (including per-session) tuning is possible via SQL and DPB.
#
# Per-database configurable.
#
#    Type: string
#
#DataTypeCompatibility =

Another alternative is to create a DB trigger on connection, as reading here: https://groups.google.com/g/firebird-support/c/B2GUqllkwpQ/m/_VnukQG1AgAJ

set term ^ ; 
CREATE TRIGGER SET_BIND_AC ACTIVE
ON CONNECT POSITION 0
AS
BEGIN
set bind of int128 to legacy;
set bind of decfloat to legacy;

set time zone 'America/Sao_Paulo';
set bind of TIME to legacy;
set bind of TIMESTAMP to legacy;
END ^
set term ; ^

Also, change TimeStamp format from D.N.Y, H:M:S.T to D.N.Y H:M:S.T at Fr View->Preferences->Data Grid

[sq8706]

soci

[arvanus]

Update: User @andy-123 are updating IBPP and Fr sources to support Fb4 data types