Bug #11730 Updated: Cannot use uniqueidentifier

ID: 11730 Updated by: fmk Reported By: thomas.reinig@onsoft.de 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@onsoft.de (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 äŒgøü‡O­²w
€Õ® ? --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11730&edit=2