[PHP-DEV] Bug #11730 Updated: Cannot use uniqueidentifier From: fmk <email protected>
Date: 06/30/01

ID: 11730
Updated by: fmk
Reported By: thomas.reinig <email protected>
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.6
Assigned To:
Comments:

UNIQUEIDENTIFYER is an alias for a 16 byte binary and as the support for binary data was changed between 4.0.5 and 4.0.6, the data returned is no longer converted to a readable string.

A new function will be introduced mssql_guid_string() in 4.0.7. This function can convert the binary value to a readable string.

If you dont want the extra call in your code, use this work arround:

select cast(id as varchar(36)) from my table

Previous Comments:
---------------------------------------------------------------------------

[2001-06-27 05:15:20] thomas.reinig <email protected>

(Apache 1.3.20, PHP4.0.6&4.0.4,MSSQL70)

Cannot work with the MSSQL-uniqueidentifier.
e.g. I need to use following select in php:

 select newid() as id;

normally I would get something like this
id="{874E725E-03A0-44C7-BB0B-E52C7EC74B9F}"

but the vars only get cryptical codes like
gOwծ ?

---------------------------------------------------------------------------

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11730&edit=2 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>