symfony7给doctrine添加json数据类型支持:

symfony7 doctrine 支持json数据类型的拓展:
composer install dunglas/doctrine-json-odm
  
json和jsonb(目前只有psql支持jsonb,而mysql不支持)：
https://www.cnblogs.com/chenyablog/p/14647273.html
配置:
doctrine:
    dbal:
        connections:
            default:
                server_version: '8.0'
                url: '%env(resolve:DATABASE_PRIMARY_URL)%'
                driver: pdo_mysql //使用mysql，需要安装对相应的php拓展
                charset: utf8mb4
                default_table_options:
                    collate: utf8mb4_unicode_ci
                mapping_types:
                    enum: string
                schema_filter: ~^(?!(messenger_messages|migration_versions)$)~
                replicas:
                    secondary:
                        url: '%env(resolve:DATABASE_SECONDARY_URL)%'
            secondary:
                url: '%env(resolve:DATABASE_SECONDARY_URL)%'
        default_connection: default
        types:
            json_document: 'Dunglas\DoctrineJsonOdm\Type\JsonDocumentType' //需要在dbal下定义这个配置
案例:
#[ORM\Column(type: 'json_document', nullable: true)]
    private string $options;