Specify the table type/storage engine in Doctrine 2

php mysql full-text-search doctrine-orm myisam
Matt Crinklaw-Vogt picture Matt Crinklaw-Vogt · Sep 23, 2011 · Viewed 9.2k times · Source

So how can one specify the storage engine to use for a given entity in Doctrine 2?

I'm creating a table that needs a full text index and only the MyISAM storage engine supports full text indexing in MySQL.

As a side: it looks like Doctrine 2 doesn't support full text indexing out of the box? Nor full text searches? Is that correct?

Answer

Gabriel ThaKid picture Gabriel ThaKid · Jul 21, 2014

I'm two years too late, but knowing this is important since it isn't documented for some reason, we have been struggling to achieve this but this is the solution

/**
 * ReportData
 *
 * @ORM\Table(name="reports_report_data",options={"engine":"MyISAM"})
 * @ORM\Entity(repositoryClass="Jac\ReportGeneratorBundle\Entity\ReportDataRepository")
 */
class ReportData
{

Related questions

PHP mysql search multiple tables using a keyword

I have three tables in my database which are: messages topics comments Each of these tables has two fields called 'content' and 'title'. I want to be able to use 'Like' in my sql statement to look at 'messages.content', …

Read More
Can't find FULLTEXT index matching the column list (indexes is set)

I'm working with fulltext, I executed an command to add the fulltext index to multiple comments, and returned no errors, then I did: SELECT * FROM products WHERE MATCH(`brand`) AGAINST('Skoda'); Which is in the brand column - but I …

Read More
How to sort MYSQL fulltext search results by relevancy

I am relatively new to MYSQL and have had an issue that has been bugging me for a while. I've tried googling all over the place for the answer, but have unable to find an acceptable solution as of yet. …

Read More