Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov Version 1.16, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all . . 22 3. Data Types and Subtypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 3.1. Integer Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.2. Floating-Point Data Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Denis Simonov, Paul Vinkenoog, Dmitry Yemanov, Mark Rotteveel Version 2.10, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all . . 24 3. Data Types and Subtypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.1. Integer Data Types . . . Floating-Point Data Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3.2.1. Approximate Floating-Point Data Types . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 4.2. Protecting User Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 4.2.2. Limiting the distribution of data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 4.2.5. Deleting stored procedure and trigger source code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 5. Embedded Firebird

........................................................................... 366 ON EXTERNAL [DATA SOURCE] ........................................................................ 366 Особенности пула Зарезервированные и ключевые слова; • Типы и подтипы данных; • Операторы DDL (Data Definition Language — язык создания данных); • Операторы DML (Data Manipulation Language — язык обращения с данными); • Операторы управления NUMERIC(4) SMALLINT NUMERIC(4,2) SMALLINT (data * 102) NUMERIC(10,4) DOUBLE PRECISION в 1-ом диалекте BIGINT в 3-ем диалекте (data * 104) Внимание Всегда надо помнить

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 6. Data Manipulation-Statements (DML) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . gespeichert als INTEGER (exact data) DECIMAL(4,2) INTEGER (data * 102) DECIMAL(10,4) (Dialekt 1) DOUBLE PRECISION (Dialekt 3) BIGINT (data * 104) 3.4. Datentypen für Datum Typen "DATE", "TIME" und "TIMESTAMP". Der SQL-Standard ruft diese Datetime- Literale auf. Syntax <data_type> 'date_literal_string' Beispiel -- 1 UPDATE PEOPLE SET AGECAT = 'SENIOR' WHERE BIRTHDATE

.............................................................................. 24 Protecting your data ................................................................................................. 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, but “free” does not mean that everything is per- mitted. The use of Firebird License) and the IDPL (Initial Developer's Public License). The first one covers the parts of the source code that were inherited from InterBase; the second applies to the additions and improvements made

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 7. Protecting your data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . org/en/documentation/. Chapter 1. About this guide 3 Chapter 2. The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is permitted. The use of Firebird License) and the IDPL (Initial Developer’s Public License). The first one covers the parts of the source code that were inherited from InterBase; the second applies to the additions and improvements made

Windows and Linux. Creates a process for each client connec- tion, each with its own cache. Less re- source use if the number of connections is low. Single server process with a separate thread for each connection significant variations from release to release of any Posix operating system, especially the open source ones. Where possible, the build engineers for each Firebird version have attempted to document any number of Firebird-specific “Firebird [Server] Manager” implementations became available through open source channels. From version 1.0.3 onward, a control panel applet is again included in the dis- tribution

◦ Create, update, query, and drop data or metadata. ◦ Input a script file containing a batch of SQL statements in sequence without prompting. ◦ Add and modify data. ◦ Grant user permissions. ◦ Perform remains uncharged. Using -ex(tract) The command line switch -ex(tract) can be used to extract meta data from the database. It can be used in conjunction with the -o(utput) switch to extract the information changes, create a new database with identical schema definitions or new ones, or create a new database source file. Using -m2 and -m(erge) The command line switch -m2, has been added in Firebird 2.0 and can

производительность WITH {AUTONOMOUS|COMMON} TRANSACTION WITH CALLER PRIVILEGES ON EXTERNAL [DATA SOURCE] AS USER, PASSWORD и ROLE Параметризованные операторы Предостережения для оператора EXECUTE Зарезервированные слова; • Типы и подтипы данных; • Операторы DDL (Data Definition Language - язык создания данных); • Операторы DML (Data Manipulation Language - язык обращения с данными); • Операторы зарезервированные слова: AUTONOMOUS, BIN_NOT, CALLER, CHAR_TO_UUID, COMMON, DATA, FIRSTNAME, GRANTED, LASTNAME, MAPPING, MIDDLENAME, OS_NAME, SOURCE, TWO_PHASE и UUID_TO_CHAR. • Более не зарезервированные, но