Understanding Doctrine Mapping Types

Doctrine Mapping Types used in the @Column annotation are neither SQL types nor PHP types but they are mapped to both. For instance, the Doctrine text type will be casted to the string PHP type in the entity and stored in a database column with the CLOB type.

The following is a correspondence table for Doctrine Mapping Type of PHP type and SQL type:

Doctrine Mapping Type	PHP Type	SQL Type
string	string	VARCHAR
integer	integer	INT
smallint	integer	SMALLINT
bigint	string	BIGINT
boolean	boolean	BOOLEAN
decimal	double	DECIMAL
date	\DateTime	DATETIME
time	\DateTime	TIME
datetime	\DateTime	DATETIME or TIMESTAMP
text	string	CLOB
object	object using the serialize() and unserialize() methods	CLOB
array	array using serialize() and unserialize() methods	CLOB
float	double	FLOAT (double precision)
simple_array	array using implode() and explode() ...