Существует набор специальных символов, используемых в качестве разделителей. ::= <space> | " | % | & | ' | ( | ) | * | + | , | - | . | / | : | ; | < | = | > | ? | [ | ] | ^ | { ::= ALPHA | UPPER | LOWER | DIGIT | ALNUM | SPACE | WHITESPACE Создание регулярных диакритическими знаками при нечувствительных к акцентам сортировках. Общие элементы языка 78 [:SPACE:] Символ пробела (ASCII 32). [:WHITESPACE:] Горизонтальная табуляция (ASCII 9), перевод строки (ASCII

set of special characters is reserved for use as operators or separators. ::= <space> | " | % | & | ' | ( | ) | * | + | , | - | . | / | : | ; | < | = | > | ? | [ | ] | ^ | { | } Chapter padded with spaces up to the declared length. Generally, the pad character does not have to be a space: it depends on the character set. For example, the pad character for the OCTETS character set is ::= [<space> ] ::= { + | - }HH:MM | time zone name (e.g. Europe/Berlin) ::= [<space>]

Sonderzeichen ist für die Verwendung als Operatoren oder Trennzeichen reserviert. ::= <space> | " | % | & | ' | ( | ) | * | + | , | - | . | / | : | ; | < | = | > | ? | [ | ] | ^ | { | } Einige ':]' ::= ALPHA | UPPER | LOWER | DIGIT | ALNUM | SPACE | WHITESPACE Aufbau Regulärer Ausdrücke Dieser Abschnitt behandelt die Elemente und Regeln zum Aufbau Strings mit groß- und kleinschreibunempfindlicher Collation sowie akzentunempfindlicher Collation. [:SPACE:] Findet das Leerzeichen (ASCII 32). Chapter 4. Allgemeine Sprachelemente 80 [:WHITESPACE:] Findet

set of special characters is reserved for use as operators or separators. ::= <space> | " | % | & | ' | ( | ) | * | + | , | - | . | / | : | ; | < | = | > | ? | [ | ] | ^ | { | } Some trailing spaces will be added to the field. Generally, the pad character does not have to be a space: it depends on the character set. For example, the pad character for the OCTETS character set is ':]' ::= ALPHA | UPPER | LOWER | DIGIT | ALNUM | SPACE | WHITESPACE Building Regular Expressions In this section are the elements and rules for building

the page size, or leave it to default. This action creates a database file, or files, with enough space allocated to create all the system tables and indices. New pages will be added to the end of the until Firebird 3.0, the next page is a Write Ahead Log page (page type 0x0a) but this page is wasted space, if present, and will most likely be dropped from Firebird 3.0 onwards. The remaining pages consist hdr_no_checksums 0x10 (bit 4) Don’t calculate checksums. hdr_no_reserve 0x20 (bit 5) Don’t reserve space for record versions in pages. Unused 0x40 (bit 6) Was used to indicate that the shared cache file

-T[RANSPORTABLE] transportable backup -- data in XDR format -USE_[ALL_SPACE] do not reserve space for record versions -USER Firebird user name -V[ERIFY] at a time -P(AGE_SIZE) override default page size -USE_(ALL_SPACE) do not reserve space for record versions gbak:general options are: -FE(TCH_PASSWORD) fetch password speeding up restores. -USE_[ALL_SPACE] This switch forces the restore to use 100% of each database page and thus not leave any room for changes. If you omit this switch, some space will be kept free for subsequent

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 12. Database Page Space Utilisation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . startup -tru(sted) use trusted authentication -u(se) use full or reserve space for versions -user default user name -v(alidate) validate database structure date, and the deleted records are so old no query ever asks for them. So there they sit, taking up space and doing no good to anyone. Even with a garbage collect thread, some active transaction has to stumble

RAND REPLACE RESTART RETURNING REVERSE ROUND RPAD SCALAR_ARRAY SEQUENCE SIGN SIN SINH SKIP SOURCE SPACE SQRT SUBSTRING TAN TANH TEMPORARY TRUNC TWO_PHASE WEEK UPDATING UUID_TO_CHAR Удалено начиная с InterBase CREATE COLLATION collname FOR charset [FROM basecoll | FROM EXTERNAL ('extname')] [NO PAD | PAD SPACE] [CASE [IN]SENSITIVE] [ACCENT [IN]SENSITIVE] [''] collname ::= имя, используемое ':]' ::= ALPHA | UPPER | LOWER | DIGIT | ALNUM | SPACE | WHITESPACE Создание регулярных выражений Символы В регулярных выражениях большинство символов

SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE, CASE INSENSITIVE, 'COLL-VERSION=58.0.6.48' UNICODE_ENUS_CS, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE, 'COLL-VERSION=58.0.6.48' SQL> show collation collation unicode_enus_ci; UNICODE_ENUS_CI, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE, CASE INSENSITIVE, 'COLL-VERSION=58.0.6.48' You can see from the output above, which is not part of details: SQL> show system collations; ASCII, CHARACTER SET ASCII, PAD SPACE, SYSTEM ... WIN_PTBR, CHARACTER SET WIN1252, PAD SPACE, CASE INSENSITIVE, ACCENT INSENSITIVE, SYSTEM If you wish to drill down

is low. A single process serves all connections, using threads to handle requests. Shared cache space. More efficient if the number of simultaneous connections grows. Permits fast, direct I/O to database Concatenation of strings The concatenation symbol in SQL is two “pipe” symbols (ASCII 124, in a pair with no space between). In SQL, the “+” symbol is an arithmetic operator and it will cause an error if you attempt if either FirstName or LastName is NULL. Otherwise it will nicely concatenate the two names with a space in between – even if any one of the variables is an empty string. Tip Think of NULL as UNKNOWN and