table (binary). Added in Firebird 2.0 UNICODE Collation works according to the UCA algorithm (Unicode Collation Algorithm) (alphabetical). Added in Firebird 2.0 UTF8 The default, binary collation, identical Functions 412 TRANSACTION_ID Same as global CURRENT_TRANSACTION variable. WIRE_COMPRESSED Compression status of the current connection. If the connection is compressed, returns TRUE; if it is not converted to string hash Cryptographic hash algorithm to apply CRYPT_HASH returns a cryptographic hash calculated from the input argument using the specified algorithm. If the input argument is not a string

data is always stored in a compressed format, even if the data itself cannot be compressed. The compression is a type known as Run Length Encoding (RLE) where a sequence of repeating characters is reduced it will be stored in full in both. The same applies to fields in the same record — all storage compression is done within each individual field and previously compressed fields have no effect on the current specialised 'dictionary' based compression routines such as LHZ, ZIP, GZ etc) Repeating short strings such as 'abcabcabc' are also not compressed. Once the compression of the data in a column has been

-CO[NVERT] backup external files as tables -E[XPAND] no data compression -FA[CTOR] blocking factor -G[ARBAGE_COLLECT) inhibit garbage collection -CO(NVERT) backup external files as tables -E(XPAND) no data compression -FA(CTOR) blocking factor -G(ARBAGE_COLLECT) inhibit garbage collection external. -E[XPAND] Normally, gbak will compress the output file. This switch prevents that compression from taking place. -FA[CTOR] If backing up to a physical tape device, this switch

SYSDBA. Firebird passwords may be up to 255 bytes long, but due to the nature of the hashing algorithm used by the Srp plugins the “effective length” is around 20 bytes, so it’s not very useful to enter

соответствия со стандарту SQL. Сортировка UNICODE использует алгоритм UCA (Unicode Collation Algorithm): a, A, á, b, B... UNICODE_CI является регистрочувствительной. При поиске, напрмер, 'Apple'

table (binary). Added in Firebird 2.0 UNICODE Collation works according to the UCA algorithm (Unicode Collation Algorithm) (alphabetical). Added in Firebird 2.0 UTF8 The default, binary collation, identical

B, a, b, a... UNICODE Сортировка работает в соответствии с алгоритмом UCA (Unicode Collation Algorithm) (алфавитная). Пример: a, A, a, b, B... UTF-8 Сортировка происходит без учёта регистра символа

0 hinzugefügt UNICODE Die Sortierung funktioniert nach dem UCA-Algorithmus (Unicode Collation Algorithm) (alphabetisch). In Firebird 2.0 hinzugefügt UTF8 Die standardmäßige, binäre Sortierung, identisch