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]