Tabulify - Boolean Data Type

Tabulify - Boolean Data Type

Boolean

This page contains the documentation about how Tabulify is managing the Boolean data type.

Storage

By default, Tabulify stores boolean data natively in the target system as boolean object.

For system, that does not support the boolean as data type, Tabulify may save them as binary integer (ie 0 or 1)

This behavior is controllable with the tabBooleanDataType tabulify connection attribute

Possible Values Description
Native (Default) Save the boolean in the data type of the system
Binary Integer (0 or 1)

Conversion

Tabulify extends the boolean system and recognize natively the following string and number as BOOLEAN (case ind├ępendant: Y or y means y) when transferring data from a system to another.

Object (case ind├ępendant) Boolean Value
true1
11
t1
yes1
y1
on1
false0
00
no0
f0
n0
off0
Empty StringNULL
naNULL
nullNULL
Powered by ComboStrap