Doctrine simple array / array transform to postgres int array?

Question

I use Doctrine 2.6.3 with Symfony 4.3.1 and Postgres 10

Unfortunately when I specify a simple_array or array column type, the Doctrine just simple create that column as TEXT, but why? Postgres supports int arrays too.

     @ORM\Column(type="simple_array", nullable=true)

I want to store some enum values here: [1, 2, 3, 4] and thats all, integers.

How can I force Doctrine to creaet int_array type for the column instead of text?

msg · Accepted Answer · 2019-09-03 21:01:03Z

3

Both array and simple_array default to text:

This type will always be mapped to the database vendor's text type internally as there is no way of storing a PHP array representation natively in the database.

If you want to leverage native types giving up on portability, you can give this doctrine dbal extension a try.

answered Sep 3, 2019 at 21:01

msg

8,2463 gold badges17 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Doctrine simple array / array transform to postgres int array?

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