. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405 8. Built-in Scalar Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 417 Table of Contents 8 8.2.6. ATAN(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . have names, often called identifiers. The maximum identifier length is 63 characters character set UTF8 (252 bytes).  It is possible to restrict the actual maximum identifier length through configuration

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305 8. Built-in Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354 Table of Contents 8 8.6.3. BIN_OR(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . n | o | p | q | r | s | t | u | v | w | x | y | z ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 2.3.2. Rules for Delimited Object Identifiers • Length cannot exceed 31 characters • The entire

Руководство по языку SQL СУБД Firebird 3.0 Firebird 3.0.4 8 августа 2018 — v.0051-1 Спонсоры документации: Platinum Sponsor Gold Sponsor Руководство по языку SQL СУБД Firebird 3.0: Firebird 3.0.4 ........................................................ 39 Последовательности сортировки для UTF-8 ....................................................... 39 Индексирование символьных типов ....... ................................................. 167 Руководство по языку SQL СУБД Firebird 3.0 8 Примеры ..........................................................................................

Обновление справочника языка SQL Всё новое в языке SQL Firebird начиная с InterBase 6 Paul Vinkenoog 8 октября 2011 года, версия 1.1 — охватывает Firebird 2.5 и 2.5.1 (Примечание переводчика: русская версия PLAN Использование COLLATE для столбцов с текстовым BLOB RETURNING ROWS UPDATE OR INSERT 8. Управление транзакциями RELEASE SAVEPOINT ROLLBACK ROLLBACK RETAIN ROLLBACK TO SAVEPOINT SAVEPOINT LN() LOG() LOG10() LOWER() LPAD() MAXVALUE() MINVALUE() MOD() NULLIF() OCTET_LENGTH() OVERLAY() PI() 8 Руководство по языку SQL POSITION() POWER() RAND() RDB$GET_CONTEXT() RDB$SET_CONTEXT() REPLACE()

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 8. Data Page — Type 0x05 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . their own storage within the database. Very large blobs will require a sequence of pages and the type 8 page holds blob data. 0x09 Generator Page. Holds an array of 64 bit generators. 0x0a Page 2 of any 0x02 - 0x03. Checksum for the whole page. No longer used, always 12345, 0x3039. Databases using ODS8 on Windows NT do have a valid checksum here.  Discussions are underway on the development mailing

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393 8. Eingebaute Skalarfunktionen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410 Inhaltsverzeichnis 8 8.2.17. LOG10(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . | v | w | x | y | z Chapter 2. SQL Sprachstruktur 20 ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 2.3.2. Regeln für getrennte Objektbezeichner • Länge darf 31 Byte nicht überschreiten. Bezeichner

........................... 8 Command-line Tools ...................................................................................................................... 8 Change to gbak -R Semantics . ......................... 8 Performance ................................................................................................................................... 8 Firebird API ............. .................................................................................. 31 Managing MSVC8 Assemblies ........................................................................................

. . . . . . . . . . 8 2.5.1. Firebird 1.5 and below. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.5.2. Firebird 2.0 and . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 3. NULL in operations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 8. Aggregate functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 8. Connecting To A Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . are passed to the engine exactly as typed in the command line. Chapter 4. Command Line Switches 8 Using `-o(utput) The OUTPUT switch allows users to store records of commands to a script file. The doesn’t appear to be any help on the SET TRANSACTION command. Chapter 7. Getting Help 13 Chapter 8. Connecting To A Database A sample database named employee.fdb is located in the examples/empbuild

. . . . . 8 3.3. Create. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 3.4. Drop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 8. Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Chapter 3. Databases 7 Parameter Description Value Optional isc_dpb_lc_ctype Character set UTF8 isc_dpb_sql_role_name User role RDB$ADMIN * isc_dpb_connect_timeout Connection timeout 10 * isc_dpb_user_name