Attachments to Doctrine Jira Issue DBAL-53 - https://github.com/doctrine/dbal/issues/1736

10798_001-doctrine-type-conversion-support-for-onetomany.diff

Index: library/Doctrine/ORM/Persisters/BasicEntityPersister.php
===================================================================
--- library/Doctrine/ORM/Persisters/BasicEntityPersister.php	(revision 635)
+++ library/Doctrine/ORM/Persisters/BasicEntityPersister.php	(working copy)
@@ -1149,7 +1149,10 @@
         $owningAssoc = $this->_class->associationMappings[$assoc['mappedBy']];
         $sourceClass = $this->_em->getClassMetadata($assoc['sourceEntity']);
         foreach ($owningAssoc['targetToSourceKeyColumns'] as $sourceKeyColumn => $targetKeyColumn) {
-            $criteria[$targetKeyColumn] = $sourceClass->reflFields[$sourceClass->fieldNames[$sourceKeyColumn]]->getValue($sourceEntity);
+            $criteria[$targetKeyColumn] = $this->_conn->convertToDatabaseValue(
+                $sourceClass->reflFields[$sourceClass->fieldNames[$sourceKeyColumn]]->getValue($sourceEntity),
+                $sourceClass->getTypeOfColumn($sourceKeyColumn)
+            );
         }
 
         $sql = $this->_getSelectEntitiesSQL($criteria, $assoc);

10799_002-doctrine-type-conversion-support-for-onetoone.diff

Index: library/Doctrine/ORM/Persisters/BasicEntityPersister.php
===================================================================
--- library/Doctrine/ORM/Persisters/BasicEntityPersister.php	(revision 640)
+++ library/Doctrine/ORM/Persisters/BasicEntityPersister.php	(working copy)
@@ -580,7 +580,10 @@
             // TRICKY: since the association is specular source and target are flipped
             foreach ($owningAssoc['targetToSourceKeyColumns'] as $sourceKeyColumn => $targetKeyColumn) {
                 if (isset($sourceClass->fieldNames[$sourceKeyColumn])) {
-                    $identifier[$targetKeyColumn] = $sourceClass->reflFields[$sourceClass->fieldNames[$sourceKeyColumn]]->getValue($sourceEntity);
+                    $identifier[$targetKeyColumn] = $this->_conn->convertToDatabaseValue(
+                        $sourceClass->reflFields[$sourceClass->fieldNames[$sourceKeyColumn]]->getValue($sourceEntity),
+                        $sourceClass->getTypeOfColumn($sourceKeyColumn)
+                    );
                 } else {
                     throw MappingException::joinColumnMustPointToMappedField(
                         $sourceClass->name, $sourceKeyColumn

10800_004-doctrine-type-conversion-support-delete.diff

Index: library/Doctrine/ORM/Persisters/BasicEntityPersister.php
===================================================================
--- library/Doctrine/ORM/Persisters/BasicEntityPersister.php	(revision 641)
+++ library/Doctrine/ORM/Persisters/BasicEntityPersister.php	(working copy)
@@ -386,6 +386,12 @@
         $this->deleteJoinTableRecords($identifier);
 
         $id = array_combine($this->_class->getIdentifierColumnNames(), $identifier);
+        foreach ($id as $column => $value) {
+            $id[$column] = $this->_conn->convertToDatabaseValue(
+                $this->_class->reflFields[$this->_class->fieldNames[$column]]->getValue($entity),
+                $this->_class->getTypeOfColumn($column)
+            );
+        }
         $this->_conn->delete($this->_class->table['name'], $id);
     }