Агрегатные функции LIST() MAX() MIN() 14. Встроенные функции ABS() ACOS() ASCII_CHAR() 7 Руководство по языку SQL ASCII_VAL() ASIN() ATAN() ATAN2() BIN_AND() BIN_OR() BIN_SHL() BIN_SHR() функции (UDF) abs acos addDay addHour addMilliSecond addMinute addMonth addSecond addWeek addYear ascii_char ascii_val asin atan atan2 bin_and bin_or bin_xor ceiling cos cosh 9 Руководство по языку SQL cot имена внутренних функций, добавленных начиная с версии Firebird 2.1. ABS ACCENT ACOS ALWAYS ASCII_CHAR ASCII_VAL ASIN ATAN ATAN2 AUTONOMOUS BACKUP BIN_AND BIN_OR BIN_NOT BIN_SHL BIN_SHR BIN_XOR BLOCK BREAK

.............................. 424 ASCII_CHAR .......................................................................................................... 424 ASCII_VAL ............................... доступны только в диалекте 3. Подробнее о диалектах см. Диалекты SQL ::= "<ASCII char>[<ASCII char> …]" Следует иметь в виду, что конечные пробелы в именах comment> ::= Структура языка 27 /*<ASCII char>[<ASCII char> …]*/ ::= --<ASCII char>[<ASCII char> …]

. 327 8.3.1. ASCII_CHAR() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327 8.3.2. ASCII_VAL() . . . . . exceed 31 characters • The name must start with an unaccented, 7-bit ASCII alphabetic character. It may be followed by other 7-bit ASCII letters, digits, underscores or dollar signs. No other characters comment> | ::= /* <ASCII char>[<ASCII char> …] */ ::= -- <ASCII char>[<ASCII char> …] Block comments start with the /* character

. 432 8.3.1. ASCII_CHAR() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 432 8.3.2. ASCII_VAL() . . . . . exceed 63 characters • The name must start with an unaccented, 7-bit ASCII alphabetic character. It may be followed by other 7-bit ASCII letters, digits, underscores or dollar signs. No other characters UTF8 (252 bytes). Identifiers are stored in character set UTF8, which means characters outside the ASCII range are stored using 2 to 4 bytes. • The entire string must be enclosed in double-quotes, e.g.

01 fe fd 00 0a 08 00 46 69 72 65 62 69 72 64 a4 00 Data[0000].ASCII: . . . . . . . F i r e b i r d . . Data[0001] 0d 00 46 69 72 65 62 69 72 64 20 42 6f 6f 6b a9 00 Data[0001].ASCII: . . . . . . . F i r e b i r d B o o k . . Data[0002].header.format: Data[0002].hex: 01 fe fd 00 02 03 00 fd 36 9f 00 Data[0002].ASCII: . . . . . . . . 6 . . Data[0003].offset: 3956 Data[0003].length:

. 419 8.3.1. ASCII_CHAR() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 419 8.3.2. ASCII_VAL() . . . . . nicht überschreiten • Der Name muss mit einem alphabetischen 7-Bit-ASCII-Zeichen ohne Akzent beginnen. Es können weitere 7-Bit-ASCII-Buchstaben, Ziffern, Unterstriche oder Dollarzeichen folgen. Andere überschreiten. Bezeichner werden im Zeichensatz UNICODE_FSS gespeichert, dh Zeichen außerhalb des ASCII-Bereichs werden mit 2 oder 3 Byte gespeichert. • Der gesamte String muss in doppelte Anführungszeichen

when the server encoding is UTF8. When other server encod- ings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify only when the server encoding is UTF8. When other server encodings are used, only code points in the ASCII range (up to \u007F) can be specified. Both the 4-digit and the 8-digit form can be used to specify when the server encoding is UTF8. When other server encod- ings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify

only when the server encoding is UTF8. When other server encodings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify when the server encoding is UTF8. When other server encod- ings are used, only code points in the ASCII range (up to \u007F) can be specified. Both the 4-digit and the 8-digit form can be used to specify only when the server encoding is UTF8. When other server encodings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify

when the server encoding is UTF8. When other server encod- ings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify only when the server encoding is UTF8. When other server encodings are used, only code points in the ASCII range (up to \u007F) can be specified. Both the 4-digit and the 8-digit form can be used to specify when the server encoding is UTF8. When other server encod- ings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify

only when the server encoding is UTF8. When other server encodings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify when the server encoding is UTF8. When other server encod- ings are used, only code points in the ASCII range (up to \u007F) can be specified. Both the 4-digit and the 8-digit form can be used to specify only when the server encoding is UTF8. When other server encodings are used, only code points in the ASCII range (up to \007F) can be specified. Both the 4-digit and the 6-digit form can be used to specify