Field Type SelectSingle

[alexander-nitsche-governikus]

Describe the bug
When not setting dbFieldLength, the default db column length of a TCA select field seems to be longtext instead of varchar(255).

To Reproduce
Steps to reproduce the behavior:

1. Create a select field in a content block without setting the dbFieldLength property.
2. Run typo3 database:updateschema
3. Verify that the auto-created select field has type "longtext" in the database.

Expected behavior
The auto-created select field should have type "varchar(255)" in the database.

TYPO3 Version
13.4.19

Content Blocks Version:
1.3.18 (composer mode)

[nhovratov]

Do you define itemsProcFunc ?

[alexander-nitsche-governikus]

No, i configured a very basic list in a "basic" element:

identifier: Vendor/Visibility
fields:
  -
    identifier: visibility
    type: Select
    renderType: selectSingle
    label: Visibility
    items:
      - value: all
      - value: desktop
      - value: tablet
    default: all

[nhovratov]

Okay, the reason for this is, that renderType is defined in columnsOverrides, but TYPO3 takes this as a basis to determine the SQL column type. So defining dbFieldLength is the correct approach in this case.

An alternative could be that Content Blocks adds a new FIeld Type "SelectSingle", where the renderType is not put into columnsOverrides. A similar approach was done for type "SelectNumber".