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:[EMAIL PROTECTED]]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP General 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]
>
>
>
--
PHP General 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]
