............................................................................ 10 2. INSTALLATION NOTES ................................................................................................. non-ASCII data then the backup/restore cycle is not enough to upgrade them to ODS 11.1. Please pay attention to the files in the /misc/upgrade/metadata directory of your Firebird 2.1 installation. Running tools and connectivity layers (drivers, components). Details are in Chapter 3 of the V.2.1.2 Release Notes, in Changes to the Firebird API and ODS. The FIREBIRD Variable FIREBIRD is an optional environment

you experience problems or if you have special needs not covered here, be sure to read the Release Notes. This is especially important if you are upgrading from a previous version or if there are remnants Firebird 5 Furthermore, you should be aware that Firebird 5 can open Firebird 4 databases, and even upgrade them, from ODS 13.0 to ODS 13.1, but won’t open databases that were created by Firebird 3 or older security database, it is also possible to copy the security4.fdb to security5.fdb and use gfix -upgrade to upgrade from ODS 13.0 to ODS 13.1, but we recommend using the backup and restore route (if only so

regression; if you use it, upgrade to 2.0.3 or higher ASAP and make sure to read your new version's Release Notes. • If you want to rely on Linux forced writes to work correctly, upgrade to at least 2.0.4. function libraries. • A sample database. • The C header files (not needed by beginners). • Release notes – essential reading! Firebird 2.0 and 2.1 Quick Start 7 Default disk locations Linux The following (referred to hereafter as ) — /opt/firebird (may vary per distribution) Release Notes and other documen- tation Various files /doc Firebird server fbserver (SS) or fb_inet_

function libraries. • A sample database. • The C header files (not needed by beginners!) • Release notes – ESSENTIAL READING! Classic or Superserver? Firebird comes in two flavors, called architectures: reason, the Guardian will attempt to restart it. Posix platforms In all cases, read the release notes that pertain to the version of Firebird that you are going to install. There may be significant variations version have attempted to document any known issues. Tip If you do not find a copy of the release notes in your kit, go back to the Downloads page of the Fire- bird website at http://firebird.sourceforge

Приложения и утилиты. 12 Руководство по языку SQL Данные темы освещены в замечаниях к релизу (Release Notes). Вы можете найти их и другую документацию по следующей ссылке: Firebird Documentation Index (http://www часть этого документа написана основным автором. Остальное (2-3%) было взято из Release Notes (замечаниях к релизу) различных версий Firebird, которые, в свою очередь, содержат материалы приведены сортировки, добавленные в Firebird. Информация в колонке «Подробно» взята из Release Notes (Примечаниях к релизу) и других документов. Информация в этой колонке, вероятно, неполная; сортировки

SUBSTRING() • UPPER() • LOWER() • BIT_LENGTH() • CHAR[ACTER]_LENGTH() • OCTET_LENGTH() • TRIM()  Notes • In 1.0.0, EXTRACT from a NULL date would crash the server. Fixed in 1.0.2. • If the first argument NULL handling, run the script ib_udf_upgrade.sql Chapter 13. User-Defined Functions (UDFs) 39 against your database. It is located in the Firebird misc\upgrade\ib_udf directory. 13.4. Being prepared therefore, the *nullif function set — is only available for Windows.  The Firebird 1 Release Notes state that, because of an engine limitation, these UDFs return a zero-equivalent if the arguments

Eine Beispieldatenbank. • Die C Headerdateien (werden von Einsteigern nicht benötigt). • Release Notes – UNBEDINGT LESEN! Classic oder Superserver? Firebird kommt in zwei Architekturen: Classic Server geeignet. Für genauere Informationen zu der Embedded Server Architektur, nehmen Sie bitte die Release Notes zur Hilfe. Standardlaufwerkspfade Nachfolgende Tabelle beschreibt die Standardlaufwerkspfade der is (nachfolgend als bezeich- net) — C:\Programme\Fire- bird\Firebird_2_0 Release Notes und andere Dokumentationen Unterschiedliche Dateien \doc Firebird Server fbserver.exe

base example. • Les fichiers d'entête C (non nécessaires pour les débutants!) • Les notes de version (release notes) - A LIRE ABSOLUMENT! Classic ou Superserver ? Firebird existe sous deux formes, appellées complètement différente et n'est pas faite pour une architecture client-serveur. Consultez les Release Notes (notes de version) pour plus de détails. Emplacements disque par défaut Le tableau suivant indique vous avez besoin de cette fonctionnalité, lisez Configurer le port de service dans les Release Notes (notes de version) livrées avec votre installation de Firebird (regardez dans le sous répertoire doc

• Образец базы данных. • Заголовочные файлы языка C (не требуются для начинающего!) • Release notes (Замечания к выпуску) – Обязательно к прочтению! Classic или Superserver? Firebird выпускается в Вашего обычных клиент-серверных инсталляций. За дополнительной информацией обращайтесь к Release Notes. Стандартное расположение на диске Далее в таблице приводится принятое по умолчанию расположение Если Вам необходима такая возмож- ность, обратитесь к разделу Configuring the port service в Release Notes, прилагаемых к Firebird (см. ди- ректорию doc). Firebird 1.5 Quick Start 6 Таблица 2. Компоненты

DML and PSQL material from the LangRef Updates, Russian language support forums, Firebird release notes, read- me files and other sources. By the end of 2014, they had the task almost complete, in the of a day represented by number n — so “- 2.25” will decrease the date by 2 days and 6 hours  Notes The DATE type is considered as TIMESTAMP in Dialect 1. See also DATEADD, DATEDIFF 3.5. Character from rdb$database Chapter 4. Common Language Elements 52 -- returns 'Säge' (4 chars, 5 bytes)  Notes The client interface determines how binary strings are displayed to the user. The isql utility,