mi215_01 - for Firebird 2.1.5 Helen Borrie (Collator/Editor) iv Table of Contents 1. Known Compatibility Issues ...................................................................................... ............................................................................... 12 Database Compatibility Among Models ................................................................................ ........................................................................................ 27 Compatibility .............................................................................................

The behaviour of FLOAT (without explicit precision) behaves as the SQL standard type REAL.  Compatibility Notes • Firebird 3.0 and earlier supported FLOAT(dec_prec) where dec_prec was the approximate FLOAT, and is provided for syntax compatibility. When used to define a column or parameter, it’s indistinguishable from using FLOAT or FLOAT(1) - FLOAT(24).  Compatibility Note • REAL has been available PRECISION The DOUBLE PRECISION data type is stored with an approximate precision of 15 digits.  Compatibility Notes • Firebird also has the — previously undocumented — synonyms for DOUBLE PRECISION: LONG

Firebird 2.0 UTF8 The default, binary collation, identical to UCS_BASIC, which was added for SQL compatibility UNICODE_CI Case-insensitive collation, works without taking character case into account. Added allocated with the help of the ib_util_malloc function from the ib_util module, a requirement for compatibility with the functions used in Firebird code and in the code of the shipped UDF modules, for allocating Statements 169  Although SET GENERATOR is considered outdated, it is retained for backward compatibility. Using the standards-compliant ALTER SEQUENCE is current and is recommended. Any user connected

information, see doc/README.security_database.txt in your Firebird 5 installation directory, or Compatibility Issues :: Upgrading a v.2.x Security Database in the Firebird 3.0 Release Notes. Chapter 3. Installing install symlinks or copies named after the 1.0 libs (with the “old” InterBase names), to maintain compatibility with third-party products which need these files. Some extra pieces are also needed for the client-only

always be created with dialect 3, which is more powerful in a number of respects. Dialect 1 is a compatibility dialect, to be used only for legacy databases that were first created Chapter 2. Generator Basics

install symlinks or copies named after the 1.0 libs (with the “old” Inter- Base names), to maintain compatibility with third-party products which need these files. Some extra pieces are also needed for the client-only

0x14 to 0x1f. To quote the source code, these values are overhead carried forward for backward compatibility. In other words, most likely unused. gpg_values An array of 64 bit values, one for each generator

misconfigured - contact administrator please -901 335545078 alter_role Deprecated backward compatibility ALTER ROLE … SET/DROP AUTO ADMIN mapping may be used only for RDB$ADMIN role -901 335545079 spb_command_line is prohibited -902 335545029 missing_data_structures Install incomplete, please read the Compatibility chapter in the release notes for this version -902 335545030 protect_sys_tab @1 operation is