OUTPUT_TYPE, OVERFLOW, PAGE, PAGE_SIZE, PAGES, PASSWORD, PRIVILEGES, PROTECTED, READ, RESERV, RESERVING, RETAIN, SCHEMA, SEGMENT, SHADOW, SHARED, SINGULAR, SIZE, SNAPSHOT, SORT, STABILITY, GROUP_COMMIT_, HELP, IMMEDIATE, INDICATOR, INIT, INPUT, ISQL, LC_MESSAGES, LC_TYPE, LEV, LOG_BUFFER_SIZE, MAX_SEGMENT, MAXIMUM, MESSAGE, MINIMUM, NOAUTO, NUM_LOG_BUFFERS, OUTPUT, PAGELENGTH, PREPARE OUTPUT_TYPE OVERFLOW PAGE PAGE_SIZE PAGES PASSWORD PRIVILEGES PROTECTED 22 Руководство по языку SQL READ RESERV RESERVING RESTRICT RETAIN ROLE SCHEMA SEGMENT SHADOW SHARED SINGULAR SIZE SNAPSHOT SORT STABILITY

страницы и набора символов, её можно вычислить по следующей формуле: max_char_length = FLOOR((page_size / 4 – 9) / N), где N — число байтов на представление символа. Таблица зачастую очень большого объёма. Типы данных 45 Синтаксис: BLOB [SUB_TYPE ] [SEGMENT SIZE ] [CHARACTER SET ] Сокращённый синтаксис: что читатель имеет некоторое знакомство с Firebird API): SELECT SH.SIZE, SH.COLOUR, SH.PRICE FROM SHIRTS SH WHERE (SH.SIZE = ? OR ? IS NULL) AND (SH.COLOUR = ? OR ? IS NULL)

Overview of Data Types Name Size Precision & Limits Description BIGINT 64 bits From -2 63 to (2 63 - 1) The data type is available in Dialect 3 only BLOB Varying The size of a BLOB segment is limited limited to 64K. The maximum size of a BLOB field is 4 GB A data type of a dynamically variable size for storing large amounts of data, such as images, text, digital sounds. The basic structural unit unit is a segment. The blob subtype defines its content CHAR(n), CHARACTER(n) n characters. Size in bytes depends on the encoding, the number of bytes in a character from 1 to 32,767 bytes A

function when explicitly converting data from one type to another Table 1. Overview of Data Types Name Size Precision & Limits Description BIGINT 64 bits From -2 63 to (2 63 - 1) Signed 64-bit integer 1 is used by default. BLOB Varying The size of a BLOB segment is limited to 64K. The maximum size of a BLOB field is 4 GB A data type of variable size for storing large amounts of data, such as content BOOLEAN 8 bits false, true, unknown Boolean data type CHAR(n), CHARACTER(n) n characters. Size in bytes depends on the encoding, the number of bytes in a character from 1 to 32,767 bytes

berechnet die maximale Länge einer indizierten Zeichenfolge (in Zeichen): max_char_length = FLOOR((page_size / 4 - 9) / N) wobei N die Anzahl der Bytes pro Zeichen im Zeichensatz ist. Die folgende Tabelle [SUB_TYPE ] [SEGMENT SIZE size>] [CHARACTER SET ] [COLLATE ] Verkürzte Syntax BLOB (size>) BLOB (size>, ) BLOB (, ) folgende Beispiel zeigt die Anwendung in der Praxis. Es nimmt zwei benannte Parameter an — sagen wir :size und :colour — die zum Beispiel Werte aus Bildschirmtextfeldern oder Dropdown-Listen erhalten können

.......................................................................... 12 Choosing a Server Model ................................................................................................. sure that you restore the security database to have a page size of at least 4 Kb. The new security2.fdb will not work with a smaller page size. Warning A simple 'cp security.fdb security2.fdb' will make chapter, Known Compatibility Issues before you set out to install Firebird 2.0. Choosing a Server Model Classic, Superserver and Embedded are all the same Firebird engine. The differences are in the ways

de- fined scope even if it has sufficient rights on the database files. Choose your authentication model (2.1 only) Firebird 2.1 and higher support three authentication models when connecting to databases account name. On Linux, the mixed model is used. On Windows, the default is mixed in 2.1, 2.1.1 and 2.1.2, and native in 2.1.3 and higher. You can change the model by setting the Authentication parameter and store it in a directory named data on your D drive: SQL>CREATE DATABASE 'D:\data\test.fdb' page_size 8192# CON>user 'SYSDBA' password 'masterkey';# Important • In the CREATE DATABASE statement it is

6. Change The Cache Size . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 6.7. Change The Page Size . . . . . . . . . . -OL[D_DESCRIPTIONS] save old style metadata descriptions -P[AGE_SIZE] override default page size -PAS[SWORD] Firebird password -R[ECREATE_DATABASE] [O[VERWRITE]] conditions -O(NE_AT_A_TIME) restore one table at a time -P(AGE_SIZE) override default page size -USE_(ALL_SPACE) do not reserve space for record versions gbak:general

cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit -104 335544763 invalid_string_constant A string constant is delimited by double quotes to allocate page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small Log partition size too small -243 335544500 no_wal Database does not use Write-ahead key_field_err Too few key columns found for index %s (incorrect column name?) -664 335544434 keytoobig Key size exceeds implementation restriction for index "%s" -677 335544445 ext_err %s extension error -685

cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit -104 335544763 invalid_string_constant A string constant is delimited by double quotes memory to allocate page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small Log partition size too small -243 335544500 no_wal Database does not use Write-ahead key_field_err Too few key columns found for index @1 (incorrect column name?) -664 335544434 keytoobig Key size exceeds implementation restriction for index "@1" -677 335544445 ext_err @1 extension error -685