Incorrect mapping of mysql tinyint(2) as boolean with doctrine

Question

I reverse engineered my database with symfony2 and doctrine with commands :

php app/console doctrine:mapping:convert
php app/console doctrine:mapping:import
php app/console doctrine:generate:entities

But my field was mapped as boolean instead of tinyint(2).

Why it is mapping as boolean?

I believe doctrine will map based on its unique values, so if that column only contains boolean values (ie. 1 or 0) then that is probably why it is being mapped as a boolean — JamesHalsall, Feb 04 '13 at 08:33
Also happened to me with tinyint(3) and tinyint(4), probably also with others but I dont know :) — Gigala, Oct 02 '13 at 08:49

score 17 · Accepted Answer · answered Feb 08 '13 at 20:51

17

tinyint (regardless of length) is mapped to type boolean in the MySQL DBAL platform.

Also, consider that the entity generator is not a reliable tool: it was just meant to give you some help in getting started with larger schemas.

answered Feb 08 '13 at 20:51

Ocramius

1 Answers1