Bug #33693 [Com]: mssql uniqueidentifier in select crashes php

Edit report at http://bugs.php.net/bug.php?id=33693&edit=1 ID: 33693 Comment by: t dot nickl at exse dot de Reported by: r dot vanicek at seznam dot cz Summary: mssql uniqueidentifier in select crashes php Status: No Feedback Type: Bug Package: Sybase-ct (ctlib) related Operating System: Linux (Debian 3.1) PHP Version: 4.4.0 Block user comment: N New Comment: This is not fixed in php 5.2.1. Did you fix it? Why is this closed? Previous Comments: ------------------------------------------------------------------------ [2008-09-11 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2008-09-03 09:53:24] pajoye@php.net Can you try using the latest 5.2.x and 5.3.0 snapshot? ------------------------------------------------------------------------ [2008-09-03 09:45:14] steveh at brendata dot co dot uk This is still an issue on the php 5.2.1, is it intended to fix this? ------------------------------------------------------------------------ [2007-09-27 10:50:41] walter at wjd dot nu You need tds version 7.0 for the bug to rear it's head. E.g. by "tds version = 7.0" in /etc/freetds/freetds.conf or with TDSVER=7.0 environment variable. (The 7.0 version transmits UCS-2 instead of ASCII which is used with 4.2) I'd really like this fixed, because I need 7.0 for working UTF8 support (with NVARCHARs in my database). When PHP is run from an apache module and the bug occurs, apache fails to serve (crashes?) any page that uses sybase-connections! #-------------------------------------------------- # Versions #-------------------------------------------------- PHP 5.2.0-8+etch7 (cli) (built: Jul 2 2007 21:46:15) Copyright (c) 1997-2006 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2006 Zend Technologies #-------------------------------------------------- # Output of my own test code using SELECT * #-------------------------------------------------- $ TDSVER=4.2 php test2.php Success! $ TDSVER=7.0 php test2.php error_handler: Data-conversion resulted in overflow. Segmentation fault (core dumped) ------------------------------------------------------------------------ [2007-07-12 21:41:58] shiftlessways at hotmail dot com This bug still seems to exist in current php 5 and 6 snapshots. I don't know how exactly there is not enough info in the original post but while the provided patch does fix the problem and work perfectly, patching php may not be an option. So altering your sql to cast the id value into a varchar before it is returned can be used as a workaround untill this ever gets fixed. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/bug.php?id=33693 -- Edit this bug report at http://bugs.php.net/bug.php?id=33693&edit=1