#106638Double json_encode when persisting an Extbase model property with database field type "JSON"
Description
When persisting an Extbase model with a property mapped to a database field of type JSON, the value gets double-encoded with json_encode.
Background: In typo3/cms-extbase/Classes/Persistence/Generic/Backend.php → persistObject(), all property values must either be strings or be converted to strings. This means an array or object must already be passed as a JSON string.
Additionally, in vendor/typo3/cms-core/Classes/Database/Connection.php → ensureDatabaseValueTypes(), the database field type is checked. If the type is json, the string is passed through json_encode again — specifically in vendor/doctrine/dbal/src/Types/JsonType.php → convertToDatabaseValue().
As a result, the field (TCA type json) is no longer recognized as valid JSON in the backend.
Workaround: Change the field type in the database from json to longtext.
Question: Is there a recommended solution or approach to preserve the use of the json field type?
Reviews 5
- 14.3 94891[BUGFIX] Honor parameter types in writable Connection methods
- main 89293[BUGFIX] Honor parameter types in writable Connection methods
- 14.3 94189[TASK] Clarify what the storage tests actually verify
- main 94182[TASK] Clarify what the storage tests actually verify
- main 90957[WIP][!!!][TASK] Disable converting values by default in `Connection`
Related issues 2
History 545
Show 220 earlier messages
-
Stefan Bürk commented and changed status
NewAccepted assigned to Stefan Bürk <span data-processor="relativetime" data-value="2025-04-30T17:10:45+00:00" > 04/30/25, 17:10 </span> -
Gerrit Code Review pushed patch set 1 for main to change 89293 status
AcceptedUnder Review <span data-processor="relativetime" data-value="2025-05-04T19:36:18+00:00" > 05/04/25, 19:36 </span> -
Gerrit Code Review pushed patch set 2 for main to change 89293 <span data-processor="relativetime" data-value="2025-05-04T19:44:50+00:00" > 05/04/25, 19:44 </span>
-
Stefan Bürk changed Related to #99062 <span data-processor="relativetime" data-value="2025-05-04T19:45:07+00:00" > 05/04/25, 19:45 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 89293 <span data-processor="relativetime" data-value="2025-05-04T19:54:01+00:00" > 05/04/25, 19:54 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 89293 <span data-processor="relativetime" data-value="2025-05-04T21:50:20+00:00" > 05/04/25, 21:50 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-08T11:14:44+00:00" > 10/08/25, 11:14 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-08T16:18:06+00:00" > 10/08/25, 16:18 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-08T16:30:57+00:00" > 10/08/25, 16:30 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-08T17:58:34+00:00" > 10/08/25, 17:58 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-08T18:40:12+00:00" > 10/08/25, 18:40 </span>
-
Gerrit Code Review pushed patch set 10 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-10T17:28:41+00:00" > 10/10/25, 17:28 </span>
-
Gerrit Code Review pushed patch set 11 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-11T16:12:14+00:00" > 10/11/25, 16:12 </span>
-
Gerrit Code Review pushed patch set 12 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-13T10:04:38+00:00" > 10/13/25, 10:04 </span>
-
Gerrit Code Review pushed patch set 13 for main to change 89293 <span data-processor="relativetime" data-value="2025-10-16T07:45:13+00:00" > 10/16/25, 07:45 </span>
-
Gerrit Code Review pushed patch set 14 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-10T12:25:51+00:00" > 11/10/25, 12:25 </span>
-
Gerrit Code Review pushed patch set 15 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-10T15:58:25+00:00" > 11/10/25, 15:58 </span>
-
Gerrit Code Review pushed patch set 16 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-10T17:45:56+00:00" > 11/10/25, 17:45 </span>
-
Gerrit Code Review pushed patch set 17 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-10T17:57:42+00:00" > 11/10/25, 17:57 </span>
-
Gerrit Code Review pushed patch set 18 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-10T18:53:32+00:00" > 11/10/25, 18:53 </span>
-
Gerrit Code Review pushed patch set 19 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-11T09:13:09+00:00" > 11/11/25, 09:13 </span>
-
Gerrit Code Review pushed patch set 20 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-11T09:14:33+00:00" > 11/11/25, 09:14 </span>
-
Gerrit Code Review pushed patch set 21 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-11T17:58:59+00:00" > 11/11/25, 17:58 </span>
-
Gerrit Code Review pushed patch set 22 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-12T12:21:31+00:00" > 11/12/25, 12:21 </span>
-
Gerrit Code Review pushed patch set 23 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-12T16:29:52+00:00" > 11/12/25, 16:29 </span>
-
Gerrit Code Review pushed patch set 24 for main to change 89293 <span data-processor="relativetime" data-value="2025-11-13T17:36:18+00:00" > 11/13/25, 17:36 </span>
-
Gerrit Code Review pushed patch set 25 for main to change 89293 <span data-processor="relativetime" data-value="2026-05-27T13:32:13+00:00" > 05/27/26, 13:32 </span>
-
Gerrit Code Review pushed patch set 26 for main to change 89293 <span data-processor="relativetime" data-value="2026-05-28T07:55:57+00:00" > 05/28/26, 07:55 </span>
-
Gerrit Code Review pushed patch set 27 for main to change 89293 <span data-processor="relativetime" data-value="2026-05-28T08:32:26+00:00" > 05/28/26, 08:32 </span>
-
Gerrit Code Review pushed patch set 28 for main to change 89293 <span data-processor="relativetime" data-value="2026-05-28T08:33:31+00:00" > 05/28/26, 08:33 </span>
-
Stefan Bürk changed Related to #109898 <span data-processor="relativetime" data-value="2026-05-28T09:12:18+00:00" > 05/28/26, 09:12 </span>
-
Gerrit Code Review pushed patch set 29 for main to change 89293 <span data-processor="relativetime" data-value="2026-05-28T09:13:20+00:00" > 05/28/26, 09:13 </span>
-
Gerrit Code Review pushed patch set 30 for main to change 89293 <span data-processor="relativetime" data-value="2026-05-28T09:19:46+00:00" > 05/28/26, 09:19 </span>
-
Gerrit Code Review pushed patch set 31 for main to change 89293 <span data-processor="relativetime" data-value="2026-05-28T14:01:29+00:00" > 05/28/26, 14:01 </span>
-
Gerrit Code Review pushed patch set 32 for main to change 89293 <span data-processor="relativetime" data-value="2026-06-02T12:11:36+00:00" > 06/02/26, 12:11 </span>
-
Gerrit Code Review pushed patch set 33 for main to change 89293 <span data-processor="relativetime" data-value="2026-06-12T07:56:41+00:00" > 06/12/26, 07:56 </span>
-
Gerrit Code Review pushed patch set 34 for main to change 89293 <span data-processor="relativetime" data-value="2026-06-12T08:30:41+00:00" > 06/12/26, 08:30 </span>
-
Gerrit Code Review pushed patch set 35 for main to change 89293 <span data-processor="relativetime" data-value="2026-06-12T08:37:13+00:00" > 06/12/26, 08:37 </span>
-
Gerrit Code Review pushed patch set 36 for main to change 89293 <span data-processor="relativetime" data-value="2026-06-12T12:16:11+00:00" > 06/12/26, 12:16 </span>
-
Gerrit Code Review pushed patch set 37 for main to change 89293 <span data-processor="relativetime" data-value="2026-07-18T00:20:07+00:00" > 07/18/26, 00:20 </span>
-
Gerrit Code Review pushed patch set 38 for main to change 89293 <span data-processor="relativetime" data-value="2026-07-18T00:20:15+00:00" > 07/18/26, 00:20 </span>
-
Gerrit Code Review pushed patch set 39 for main to change 89293 <span data-processor="relativetime" data-value="2026-07-22T13:21:58+00:00" > 07/22/26, 13:21 </span>
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 94891 <span data-processor="relativetime" data-value="2026-07-23T07:42:33+00:00" > 07/23/26, 07:42 </span>
-
Stefan Bürk commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-07-23T07:55:09+00:00" > 07/23/26, 07:55 </span>Applied in changeset commit:5ca75e82645c82397bde145b12b2ba7c334ca195.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2026-08-11T08:46:39+00:00" > 08/11/26, 08:46 </span>
Extbase never had “json” support, and misses TCA type=json (DB type json) support.
At least the double encoding should be prevented in the first step and as “bugfix”,
literally ignoring TCA/DB Type json for now.
In v14 support for extbase (DECODE + ENCODE) can be added in a dedicated step,
which is not really suitable as bugfix due to changes required for models I guess.