Saving Datetime Immutable object as Datetime in database with Symfony and Doctrine without default comment

Question

I'm building the Symfony entities from the existing database dump, and decided to switch from Datetime objects to Datatime Immutable, which don't have to change anything in database. But in the migration I see that it's adding the default comment, which I want to get rid of

'ALTER TABLE application_settings CHANGE updated_at updated_at DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)'');

DB is Mysql.

Here's my Datetime Immutable property in the entity:

#[ORM\Column(name: 'updated_at', type: Types::DATETIME_IMMUTABLE, nullable: true)]
private ?\DateTimeImmutable $updatedAt = null;

Didn't find anything about this issue in the internet. Is there any way to get rid of this comment?

I think doctrine uses comment to store metadata on the field, since datetime_immutable isn't a MySQL type. But I'm not sure that's what you mean by "default comment" — Maniax
– Maniax, Commented Nov 15, 2022 at 18:53
This modification has no impact on the data. It just indicates for Doctrine that the data type is datetime_immutable and allows the library to correctly hydrate it. — Spomky-Labs
– Spomky-Labs, Commented Nov 16, 2022 at 14:12

Boolean_Type · Accepted Answer · 2025-11-20 17:13:20Z

0

There is an option in /packages/doctrine.yaml (actual for DBAL3. As I know, DBAL4 doesn't generate such comments):

doctrine:
    dbal:
        # ...
        disable_type_comments: true

edited Nov 20 at 17:13

answered Nov 20 at 17:06

Boolean_Type

1,3423 gold badges14 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving Datetime Immutable object as Datetime in database with Symfony and Doctrine without default comment

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related