Bug #54167 [Fbk->Opn]: PDO_DBLIB returns null on SQLUNIQUE field

Edit report at http://bugs.php.net/bug.php?id=54167&edit=1 ID: 54167 User updated by: mjh at hodginsmedia dot com Reported by: mjh at hodginsmedia dot com Summary: PDO_DBLIB returns null on SQLUNIQUE field -Status: Feedback +Status: Open Type: Bug Package: PDO related Operating System: Linux PHP Version: 5.3.5 Block user comment: N Private report: N New Comment: Value is returned from dbconvert in lowercase. The call to php_strtoupper() normalizes the value to make it consistent with other tools. For example the MS SQL client tools always show the value as a string in uppercase. Also php_mssql.c PHP function mssql_guid_string() does the same thing. Previous Comments: ------------------------------------------------------------------------ [2011-03-05 14:19:21] felipe@php.net Why php_strtoupper(val->data, val->len); is needed? ------------------------------------------------------------------------ [2011-03-05 08:15:58] mjh at hodginsmedia dot com Description: ------------ SQLUNIQUE (type 36) is a uniqueidentifier field in Microsoft SQL server. It is presently unhandled by PDO_DBLIB, so returns NULL rather than the actual column value for all queries. Patch to ext/pdo_dblib/dblib_stmt.c is attached which fixes the issue so that PDO_DBLIB returns the uniqueidentifier as a string. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=54167&edit=1