Skip to content

Binary Boolean (0/1)

Type Registry

Binary Boolean (0/1)

representation.boolean.binary

Boolean value represented as a binary digit: "0" for false, "1" for true. Common in CSV exports, database dumps, and flag columns. Transforms to DuckDB BOOLEAN type.

Domain representation›boolean
Casts to BOOLEAN
Scope Universal

Try it

CLI 
$ finetype infer -i "0"
→ representation.boolean.binary

DuckDB

Detect 
SELECT finetype('0');
-- → 'representation.boolean.binary'
Cast expression 
CAST({col} AS BOOLEAN)
Safe cast pipeline 
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS BOOLEAN) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'representation.boolean.binary';

JSON Schema

finetype schema representation.boolean.binary 
{
  "$id": "https://noon.sh/schemas/representation.boolean.binary",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Boolean value represented as a binary digit: \"0\" for false, \"1\" for true. Common in CSV exports, database dumps, and flag columns. Transforms to DuckDB BOOLEAN type.",
  "enum": [
    "0",
    "1"
  ],
  "examples": [
    "0",
    "1"
  ],
  "title": "Binary Boolean (0/1)",
  "type": "string"
}

Examples

01

Also known as

binary_boolbit

Types in representation