How to get Doctrine TEXT type?

Question

I have this annotation:

/**
 * @ORM\Column(name="notes", type="string", length=65532, nullable=true)
 */
protected $notes;

According to this document - http://doctrine-dbal.readthedocs.org/en/latest/reference/types.html#id102 because it's less than 65535 it should be TEXT?

But the column is created as MEDIUMTEXT.

How do I fix this?

Answer 1

You need to set the length:

To TINYTEXT => length = 255
To TEXT => length = 65535
To MEDIUMTEXT = 16777215
Default: LONGTEXT

Then, for example if you need an type text, it's necessary:

/**
* @ORM\Column(name="description", type="text", length=65535)
*/

Answer 2

You are referencing not correct type in the documentation. In your code you have type="string" but your reference to documentation is related to type="object".

If you read the part of table above in the referenced docs you will see that string is casted to VARCHAR in MySQL if length does not exceed the maximum length for MySQL and is casted to MEDIUMTEXT if length exceeds.

But If you want to get explicitly TEXT field you will need to define your column with type="text".