BINARY, VARBINARY, BINARY VARYING

IBExpert support since version 2018.12.15.

Source: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.data_types

Function

Alias for CHAR, VARCHAR, VARYING CHAR with CHARACTER SET OCTETS.

Author Dimitry Sibiryakov

Syntax rules

  BINARY[(length)]
  VARBINARY(length)
  BINARY VARYING(length)

Example(s)

  1. DECLARE VARIABLE VAR1 VARBINARY(10);
  2. CREATE TABLE TABLE1 (FIELD1 BINARY(16),
                          FIELD2 VARBINARY(100),
                          FIELD3 BINARY VARYING(1000));

Note(s)

• If length is omitted for type BINARY, it is considered to be 1.
• Can be distinguished from text types by value 1 in RDB$FIELD_SUB_TYPE.
• Character set is set to OCTETS for backward compatibility.
• In API are similar to corresponding text types, getSubType() returns 0.