Re: RE: [PHP] mssql and uniqueidentifier's

Hi all, The dll is not broken. The type UNIQUEIDENTIFYER is a 16 byte binary value and is returned as such. With versions of the php_mssql.dll distributed with php4.0.5 or before did not include proper support for binary data. This has been changed in php4.0.6. I have hust added a small function to the extension called mssql_guid_string(). This function can be used to convert the binary value into a readable string. This function will be available in php4.0.7. If you want a copy of the dll before the release of php4.0.7, please email me directly. You could also let the server handle the convertion "select id from mytable" will return binary data if id is a UNIQUEIDENTIFIER. "select case(id as varchar(36)) from mytable" will do the convertion on the server and return a valid string. - Frank > well, the SQL statement you're trying to execute > would help determine why it's not working... :) > > just stating that "it's broken" is like saying > "my car makes this funny noise" and hoping that > a mechanic will give you a detailed diagnosis. > > > > -----Original Message----- > > From: Thomas Häger [mailto:thomas.haeger@onsoft.de] > > Subject: [PHP] mssql and uniqueidentifier's > > > > > > Hi NG, > > > > my problem is following: > > > > I made a query on a table on a MS SQL Server 2000. The table have a > > key-column from type uniqueidentifier. Ever i made a query on this column, > > the result is not right. It comes back some crypt. > > > > For example: > > > > Value Database: 496467D1-7646-4094-8016-087083EA9432 > > Result shown in the browser, queried by php : ÑgdIFv"@?pfê"2 > > > > > > Can somebody help me, thanks, > > > > Thomas > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >