Table of Contents

Property UseBooleanDataType

Namespace
YndigoBlue.Velocity.Data.Oracle
Assembly
YndigoBlue.Velocity.dll

UseBooleanDataType

Gets or sets whether to use Oracle's native boolean data type (Oracle 23c+).

public bool UseBooleanDataType { get; set; }

Property Value

bool

Remarks

Oracle 23c introduced a native BOOLEAN data type. When enabled, boolean columns map to Oracle's BOOLEAN type. When disabled, boolean columns map to NUMBER(1), storing 0 for false and 1 for true.

When to Enable (Oracle 23c+):

  • You are running Oracle Database 23c or later and want to use the native boolean type for cleaner, more semantically correct schema design.

When to Disable (Oracle pre-23c):

  • Running pre-23c Oracle databases where BOOLEAN is not a valid column data type. Setting this to true on these versions will cause schema creation and table creation to fail.
  • Querying existing tables where boolean columns are already stored as NUMBER(1).