KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: Storing Binary Values in Long Integers
PRODUCT: 4D | VERSION: 6.5 | PLATFORM: Mac & Win
Published On: February 1, 2000

Longint fields are coded in 32 bits, which provides a range of values between - 2,147,483,648 and + 2,147,483,648. It is also possible to use those bits to store 32 distinct boolean values such as Yes/No, True/False, or Male/Female Ñ values that would usually be associated with check boxes or radio buttons in a form. It is also possible to extend that method to store multiple-choice data by using more than one bit.





Preliminary Note: The database provided with this technical note is designed to be used in compiled mode. If you use the interpreted version, please keep in mind that its performance will be seriously impaired.

Tech Note