Doctrine Mssql uniqueidentifier isn't cast as char or nvarchar when retrieved from the database.

Posted by Tres on Stack Overflow See other posts from Stack Overflow or by Tres
Published on 2010-05-04T05:43:30Z Indexed on 2010/05/04 5:48 UTC
Read the original article Hit count: 410

Filed under:

doctrine

|

mssql

|

php

|

uniqueidentifier

|

null-uniqueidentifier

When I retrieve a record from the database which has a column of type "uniqueidentifier", Doctrine fills it with "null" rather than the unique id from the database.

Some research and testing has brought this down to a PDO/dblib driver issue. When directly querying via PDO, null is returned in place of the unique id.

For reference, http://trac.doctrine-project.org/ticket/1096, has a bit on this, however, it was updated 11 months ago with no comment for resolution.

A way around this, as mentioned at http://bugs.php.net/bug.php?id=24752&edit=1, is to cast the column as a char. However, it doesn't seem Doctrine exposes the native field type outside of generating models which makes it a bit hard to detect uniqueidentifier types and cast them internally when building the sql query.

Has anyone found a workaround for this?

© Stack Overflow or respective owner

Related posts about doctrine

Doctrine::Windows::How generate Doctrine Models on windows?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How generate Doctrine Models from database on windows? (I working with zend studio and zend framework) >>> More
Dotrine::Zend::How generate new doctrine models without delete doctrine models classes with my code

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I build zend app with doctrine. The problem is when i add new tables to database and I should generate doctrine models, because I add my own code to Doctine generated classes- I dont wont to delete them. I solve this problem like that: 1. copy old generated doctine models classes to other folder 2… >>> More
(Doctrine-Ubuntu) Get error: doctrine-cli.php: command not found

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, (Doctrine-Ubuntu) I run $ doctrine-cli.php command and get doctrine-cli.php: command not found. P >>> More
Doctrine 2 Cannot find entites

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Kohana 3 and have a /doctrine/Entites folder with my entities inside. When executing the code $product = Doctrine::em()->find('Entities\Product', 1); in my controller, I get the error class_parents(): Class Entities\Product does not exist and could not be loaded Below is the Controller… >>> More
php doctrine last identifier issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running in to the issue below when trying to run the following: $store = new Store(); $store->url =$this->form_validation->set_value('website'); $store->save(); $store_id = $store->identifier(); Fatal error: Uncaught exception 'Doctrine_Connection_Exception' with message 'Couldn't… >>> More

Related posts about mssql

Fixing my SQL Directory NTFS ACLS

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I run my development server by boot to VHD (Windows Server 2008 R2 x64). In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler). That VHD I have my SQL instances installed. So, the other day, acting hasty, I chmod my ACLS – wow, what a day after… >>> More
Restore Database from MSSql 2008 to MSSql 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello... I have created a set of tables (around 20) in MSSql 2008 and entered around 1000 records to appropriate tables. But the issue is that I want that same tables with all the entered data into MSSql 2005 (SQLEXPRESS). Obviously it won't work by taking a backup and restore it into MSSql 2005… >>> More
Recover Data Entered in MSSql 2008 to MSSql 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello... I have created a set of tables (around 20) in MSSql 2008 and entered around 1000 records to appropriate tables. But the issue is that I want that same tables with all the entered data into MSSql 2005 (SQLEXPRESS). Obviously it won't work by taking a backup and restore it into MSSql 2005… >>> More
Plans for our next milestone

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have seen some increase in activity with more people downloading our driver and either reporting their successes or reporting any issues they run into – for the native driver (sqlsrv_xxxx API) to the PDO driver (PDO API). We’d like to thank you all for your effort and hope that our… >>> More
SQL Server Driver for PHP 2.0 CTP2 is now released

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
digg_url = "http://blogs.msdn.com/b/sqlphp/archive/2010/06/15/sql-server-driver-for-php-2-0-ctp2-is-now-released.aspx";digg_title = "SQL Server Driver for PHP 2.0 CTP2 is now released";digg_bgcolor = "#FFFFFF";digg_skin = "normal"; digg_url = undefined;digg_title… >>> More