for delimiting string data. This is contrary to the SQL standard — double quotes are reserved for a distinct syntactic purpose both in standard SQL and in Dialect 3. Double-quoting strings is therefore FULLNAME in the metadata. 2.4. Literals Literals are used to directly represent data. Examples of standard types of literals are: integer - 0, -34, 45, 0X080000000; fixed-point - 0.0, -3.14 floating-point 807. 3.1.4. INT128 INT128 is a 128-bit integer data type. This type is not defined in the SQL standard. Numbers of the INT128 type are within the range from -2 127 to 2 127 - 1. Chapter 3. Data Types

to unexpected runtime errors. CHECK Constraint Change Formerly, CHECK constraints were not SQL standard-compliant in regard to the handling of NULL. For example, CHECK (DEPTNO IN (10, 20, 30)) should been reimplemented (XNET instead of IPServer). With regard to the local protocol, the new client library is therefore incompatible with older servers and older client libraries are incompatible with the deployments, a local client and a server are rolled together into one shared object library. - On Windows, the embedded server library is named fbembed.dll. It is a temporary file name that must be changed in order

The translated text would be edited and converted to the Project’s standard DocBook format for addition to the open document library of the Firebird Project. From there, the source text would be available available for translation into other languages for addition to the library. The fund-raising campaign happened at the end of 2014 and was successful. In June, 2015, professional translator Dmitry Borodin English, editing of the raw, translated text and conversion of the whole into the Firebird Project’s standard DocBook 4 documentation source format. Chapter 1. About the Firebird SQL Language Reference: for

file -i(nput) input file (set input) -m(erge) merge standard error -m2 merge diagnostic -n(oautocommit) no autocommit operating system. Chapter 8. Connecting To A Database 14 8.1. Connection Strings The Firebird client library — and by extension, isql — supports a variety of connection strings. Connection String Syntax only available on Windows. The actual supported connection strings depends on the Firebird client library in use (fbclient.dll /libfbclient.so). The service refers to a service definition in the services

Firebird server: • The Firebird server executable. • A client library located on the server machine. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The Utility (isql). Performing a client-only install Each remote client machine needs to have the client library – libgds.so on Posix clients, gds32.dll on Windows clients – that matches the release version of management system has its own idiosyncrasies in the ways it implements SQL. Fire- bird adheres to the SQL standard more rigorously than any other RDBMS except possibly its “cousin”, InterBase®. Developers migrating

1-Datenbanken behalten bestimmte Sprachfunktionen bei, die sich von Dialekt 3 unterscheiden, dem Standard für Firebird-Datenbanken. ◦ Datums- und Uhrzeitinformationen werden im Datentyp DATE gespeichert Zeichenfolgendaten verwendet werden. Dies steht im Gegensatz zum SQL-Standard – doppelte Anführungszeichen sind sowohl in Standard-SQL als auch in Dialekt 3 für einen bestimmten syntaktischen Zweck reserviert Deklaration entspricht. HINWEIS: Das Verhalten von NUMERIC und DECIMAL in Firebird entspricht dem SQL-Standard DECIMAL; die Genauigkeit entspricht mindestens der Deklaration. Chapter 3. Datentypen und Untertypen

The Firebird server executable. • One or more client libraries. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners) this guide. Performing a client-only install Each remote client machine needs to have the client library – libfbclient.so on Posix clients, fbclient. dll on Windows clients – that matches the release version connect to. Tools from Classic distributions terminate immediately if they can't find the libfbembed library (which is useless for network connections) upon program start. Instead of copying the files from

made. 3.5. Performing a client-only install Each remote client machine needs to have the client library — libfbclient.so on POSIX clients, fbclient.dll on Windows clients — that matches the release version locations The tables below show you where you’ll find the Firebird files and directories after a standard installation. Please notice that the listings are not exhaustive. 4.1. Linux The following table table) Some necessary Microsoft runtime libs msvcp140.dll, vcruntime140.dll $(install) 32-bit library versions for use with 64-bit Firebird fbclient.dll, msvcp140.dll, vcruntime140.dll $(install)\WOW64

| CSTRING(length) | PARAMETER param_num } [FREE_IT] ENTRY_POINT 'entry_point' MODULE_NAME 'library_name'; ::= sqltype [{BY DESCRIPTOR} | NULL] | CSTRING(length) [NULL] внешней функции. Может содержать до 31 байта. entry_point Имя экспортируемой функции (точка входа). library_name Имя модуля, в котором расположена функция. sqltype Тип данных SQL. Не может быть массивом или Синтаксис: ALTER EXTERNAL FUNCTION funcname [ENTRY_POINT 'new_entry_point'] [MODULE_NAME 'new_library_name']; Таблица 4.35. Параметры оператора ALTER EXTERNAL FUNCTION Параметр

through the entire set. 5.3.2. SINGULAR SINGULAR is an InterBase/Firebird extension to the SQL standard. It is often described as returning true if exactly one row in the subquery meets the search condition defined in separate modules. Firebird ships with two UDF libraries: ib_udf (a widely used “InterBase library”) and fbudf. You can add more libraries, e.g. by buying or downloading them, or by writing them (UDFs) 38 “by descriptor”. Descriptors allow NULL signalling no matter the type of data. The fbudf library makes ample use of this technique. Unfortunately, using descriptors is rather cumbersome; it’s