Firebird 2.1 Error Codes Firebird 2.1 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 101 335544366 segment Segment buffer length shorter than record. -85 335544757 error_updating_sec_db An error occurred while updating the security Firebird 2.1 Error Codes database. -103 335544571 dsql_constant_err Data type for constant unknown -104 336003075 delimited by double quotes -104 335544764 transitional_date DATE must be changed to TIMESTAMP Firebird 2.1 Error Codes -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect @1 does not support reference

......................................................................... 1 Changes to Note in V.2.1 .................................................................................................. issues that need to be attended to in migrating to v.2.1, in addition to the v.2.0 issues that you have previously taken care of. Changes to Note in V.2.1 Metadata Need to be Upgraded If your databases contain ODS 11.1. Please pay attention to the files in the /misc/upgrade/metadata directory of your Firebird 2.1 installation. Running Multiple Instances The configuration parameter CreateInternalWindow in firebird

Firebird 2.1. Если у вас более ранняя версия Firebird или вы в первый раз устанавливаете его, то вам лучше пропустить этот раздел. Зарезервированные и ключевые слова Изменения начиная с Firebird 2.1: • Изменения начиная с Firebird 2.1: • Шестнадцатеричные обозначения цифр • Шестнадцатеричные обозначения «двоичных» строк Типы и подтипы данных Изменения начиная с Firebird 2.1: • Тип данных SQL_NULL UTF8, сортировка GB18030 для GB18030 Язык определения данных (DDL) Изменения начиная с Firebird 2.1: • ALTER CHARACTER SET (установка сортировки по умолчанию для набора символов) • Параметр NUMERIC-SORT

Firebird 2.0 and 2.1 Quick Start Guide IBPhoenix Editors Firebird Project members 11 July 2011, document version 3.11 covers Firebird 2.0–2.0.6 and 2.1–2.1.4 2 Table of Contents About this guide on, verify that this guide matches your Firebird version. This guide covers versions 2.0– 2.0.6 and 2.1–2.1.4. For all other Firebird versions, get the corresponding Quick Start Guide at http://www. firebirdsql want to rely on Linux forced writes to work correctly, upgrade to at least 2.0.4. Firebird 2.0 and 2.1 Quick Start 4 The Firebird licenses Firebird is a free, open-source database management system,

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.1. Vorteile von nbackup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 4.4. Datenbanktrigger unterdrücken (Firebird 2.1+). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.5. Direkte neuen Datenbank wiederherstellen. In dieser Hinsicht unterscheidet sich nbackup nicht von gbak. 2.1. Vorteile von nbackup • Beide Modi: hohe Geschwindigkeit (so hoch wie es Hardware und Betriebssystem

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.1. Common Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . caveats, gotchas and foibles of gbak. Chapter 1. Introduction 2 Chapter 2. Command-line Options 2.1. Common Options When running gbak in backup or restore mode, there are a number of options which apply Firebird 2.1 gbak: Version(s) for database employee Firebird/linux (access method),version LI-V2.1.3.18185 Firebird 2.1 Firebird/linux (remote server),version LI-V2.1.3.18185 Firebird 2.1/tcp (tux)/P11

Zeitpunkt des Schreibens korrekt und gilt, sofern nicht anders angegeben, nur für Firebird 1.5, 2.0 und 2.1 Super Server, die auf einem Linux-System installiert sind. Andere Unix-Varianten haben möglicherweise zu ändern, das in der Datei / opt / firebird / SYSDBA.password verbessert ist. Bis zur Version 2.1 von Firebird wird das Kennwort entwickelt im Startskript /etc/rc.d/init.d/firebird verwendet Verwendung von Firebird 2.1 und höher, da für das Startskript das SYSDBA-Kennwort nicht mehr erforderlich ist. Im obigen Beispiel wird die letzte Ausgabezeile auf Systemen mit Firebird 2.1 und höher nicht

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.1. Disallowing NULL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . is taken and/or a non-NULL result is returned). They are discussed in the following paragraphs. 2.1. Disallowing NULL In a column or domain definition, you can specify that only non-NULL values may doesn’t happen anymore: it’s either false vs. true or twice NULL. The code has been fixed for Firebird 2.1; from that version onward SINGULAR will return: • false if the search condition is never true (this

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2.1. Background to Firebird’s SQL Language . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Chapter 2. SQL Language Structure This reference describes the SQL language supported by Firebird. 2.1. Background to Firebird’s SQL Language To begin, a few points about some characteristics that are UNICODE_CI Case-insensitive collation, works without taking character case into account. Added in Firebird 2.1 UNICODE_CI_AI Case-insensitive, accent-insensitive collation, works alphabetically without taking

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 2.1. Background to Firebird’s SQL Language . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Chapter 2. SQL Language Structure This reference describes the SQL language supported by Firebird. 2.1. Background to Firebird’s SQL Language To begin, a few points about some characteristics that are UNICODE_CI Case-insensitive collation, works without taking character case into account. Added in Firebird 2.1 UNICODE_CI_AI Case-insensitive, accent-insensitive collation, works alphabetically without taking