Doctrine custom data type

mysql symfony orm doctrine dbal
Websirnik picture Websirnik · Jan 29, 2011 · Viewed 8.5k times · Source

I'm developing application with Symfony2. Symfony2 is using Doctrine 2 for DBAL and ORM. As far as I know Doctrine2 doesn't have suport for BLOB data type. However I want to implement BLOB support through the custom data type mapping:

http://www.doctrine-project.org/docs/dbal/2.0/en/reference/types.html

However I'm struggling to understand where should this part go.

<?php
Type::addType('money', 'My\Project\Types\MoneyType');
$conn->getDatabasePlatform()->registerDoctrineTypeMapping('MyMoney', 'money');

Is anybody was going through it?

The reason I need a BLOB type is that I want to import mapping from existing MySQL database.

Answer

tiruncula picture tiruncula · Jan 8, 2016

Another solution would be to register your Custom Type in the config file

You just need to add that in your config file:

# app/config/config.yml
doctrine:
    dbal:
        types:
            money:  My\Project\Types\MoneyType

You can find more info on how to register a custom mapping type in this Symfony Cookbook entry

Related questions

Symfony 2: INNER JOIN on non related table with doctrine query builder

I'm trying to build a query with the doctrine query builder which joins a non related table like this: $query = $this->createQueryBuilder('gpr') ->select('gpr, p') ->innerJoin('TPost', 'p') ->where('gpr.contentId = p.…

Read More
Troubleshooting "No such file or directory" when running `php app/console doctrine:schema:create`

I am new to Symfony2 (beta4) and Doctrine and am having issues when i try to create the DB schema via command line. Here's the error: $ php app/console doctrine:schema:create Creating database schema... [PDOException] SQLSTATE[HY000] [2002] No such …

Read More
Doctrine2 migrations migrate down and migrate from browser and not command line

I am using Doctrine2 migrations. I need some answers about my doubt, I canno find a good solution in documentations I use: doctrine migrations:diff // generate migrations files doctrine migrations:migrate // migrates up to new version How Can I migrate …

Read More