Stack Overflow
Stack Overflow

Questions tagged [firebird-4.0]

For questions specific to Firebird 4.0. It is advisable to also tag with firebird.

Firebird 4.0 is the latest release of the Firebird database server.

Notable new features

  • Time zone support (TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE
  • Decimal floating points (DECFLOAT)
  • Increased maximum precision of NUMERIC and DECIMAL to 38 digits
  • Introduction of INT128 (128 bit integer)
  • Increased identifier length to 63 characters
  • Asynchronous and synchronous replication
  • Lateral derived tables
  • Built-in functions for encryption and cryptographic hashes
  • Built-in functions for encoding and decoding Base64 and hex
  • Extensive system privileges and ability to assign automatic roles
  • Engine and database configuration (read-only) exposed through virtual table RDB$CONFIG
  • Batch execution of statements
  • ... and a lot more, see Firebird 4.0 Release Notes

Resources

See also

18 questions
0
votes
1 answer

Insert content of (text) file with isql into table field

With Firebird, the databases can be edited quite comfortably via isql. Now I have a database where in one field VALCONTENT BLOB SUB_TYPE TEXT SEGMENT SIZE 80 contains a continuous text. I would now like to write the content of a text file into…
ralfiii
  • 584
  • 4
  • 13
0
votes
2 answers

Trying to connect to Firebird 4.0 from remote always generate error "connection rejected by remote interface"

I am trying to connect to Firebird 4.0 on my server from a remote PC but always failed. It always reports: "connection rejected by remote interface." My server uses Windows Server 2012 R2. I already test using telnet to my server on port 3050 and it…
Ongky
  • 39
  • 1
  • 4
0
votes
1 answer

Firebird 4.0 release candidate 1 in C can't open embedded database

I am using Firebird 4.0 release candidate 1 on Linux (attempting to use it either in a C application or with the ODBC driver). When I attempt to open an embedded database (/path/to/db/name.db), I get "Unable to complete network request to host XXX.…
mlawsonca
  • 103
  • 1
  • 6
1
2