Skip to main content

Boolean types

Boolean types

Abstract

Boolean types

Section

Description

BIT

BIT is a FairCom database field type containing a Boolean value of 0 or 1.

BIT

BIT is a FairCom database field type containing a Boolean value of 0 or 1. It is stored in a record as an 8-bit integer.

BIT's behavior in different APIs:
  • In FairCom's JSON DB API, a BIT value is represented as a JSON Boolean with a value of false or true.

    A field value of 0 maps to false. A field value of 1 maps to true.

  • In FairCom's SQL API, a BIT value is submitted and returned as a 0 or 1 ASCII characters.

  • In FairCom's ISAM and CTDB APIs, a BIT value is submitted and returned as an unsigned byte with a value of 0 or 1.