---
title: "Important: #105441 - TCA select fields with null item values create nullable columns"
manual: "TYPO3 Core Changelog"
version: "main"
permalink: "https://docs.typo3.org/permalink/changelog:important-105441-1737992400"
source: "Changelog/14.2/Important-105441-TCASelectFieldsWithNullItemValuesNowCreateNullableIntegerColumns.rst"
typo3-version: "14.2"
typo3-major: 14
type: "important"
issue: 105441
forge: "https://forge.typo3.org/issues/105441"
tags: ["Database", "TCA", "ext:core"]
rendered: "2026-09-20T18:31:11+00:00"
---

# Important: #105441 - TCA select fields with null item values create nullable columns {#important-105441-1737992400}

See [forge#105441](https://forge.typo3.org/issues/105441)

## Description {#description}

When a TCA `select` field is configured as `renderType => 'selectSingle'`
and an item is added with `'value' => null`, the database column that is generated is
now nullable regardless of whether the other item values are integers or strings.

Previously, the following configuration with integer item values incorrectly
generated a `VARCHAR(255)` column:

```php
'config' => [
    'type' => 'select',
    'renderType' => 'selectSingle',
    'foreign_table' => 'some_table',
    'default' => null,
    'items' => [
        ['label' => 'Please choose', 'value' => null],
    ],
],
```

This now correctly generates `INT UNSIGNED DEFAULT NULL`.

Similarly, configuration with string item values now also generates a
nullable column:

```php
'config' => [
    'type' => 'select',
    'renderType' => 'selectSingle',
    'default' => null,
    'items' => [
        ['label' => 'Default', 'value' => null],
        ['label' => 'Option', 'value' => 'some_value'],
    ],
],
```

This now correctly generates `VARCHAR(255) DEFAULT NULL` instead of
`VARCHAR(255) DEFAULT '' NOT NULL`.
