ID: 11730
Updated by: fmk
Reported By: [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] [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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
