#97616Bodytext of default Language shown in Translation on NULL
Description
Problem:
Translated content elements are showing the bodytext content of the default language instead of nothing when value is NULL instead of empty string ''
Short:
- Language is set to “strict” mode in site configuration.
- Content element (= ce) is translated using the connected mode.
- Bodytext field value of translation is
NULLinstead of empty string'' - Bodytext field of default language has some content.
—-
How to reproduce?
- Setup TYPO3 10/11/main with at least two languages. Use strict mode.
- Create a ce “Header”.
- Then translate this ce (connected mode).
- Edit the ce in the default language:
- Switch type to “Text & Media”
- Add some content to the bodytext field
Optional Steps:
- Change the translated ce also to “Text & Media” and save. But DON’T touch the bodytext field!
- Check your database: Is the bodytext value
NULLor''
When you create a textmedia directly or delete text from the bodytext with the RTE, the field will be saved as empty string.
The field is defined as bodytext mediumtext, in the ext_tables.sql. Therefore IMHO NULL and empty string '' should behave the same way.
—
You find example data for a very basic setup attached (Site config + Dump: sys_template, pages & tt_content)