Bug #15371 Updated: corrupted/erroneous data output

ID: 15371 Updated by: jedgar@woodtruss.com Reported By: jedgar@woodtruss.com Status: Open Bug Type: MSSQL related Operating System: Red Hat 7.2 PHP Version: 4.1.1 New Comment: Of course, right after submitting the report, I tried changing the FreeTDS version to 4.2. The data was output correctly. However, why did SQSH work at 7.0, when it sits on top of FreeTDS, and not PHP? Previous Comments: ------------------------------------------------------------------------ [2002-02-04 16:49:47] jedgar@woodtruss.com We are attempting to MSSQL using FreeTDS 0.53 running 7.0. I have successfully connected to the MSSQL 2000 database; however, when I output the results of a query, it appears as though trailing characters from the previous row are being added to the current row. This happens whether I output using the ADODB system, or use PHP's Sybase commands. However, when I use SQSH 2.1, it outputs the data correctly. This points to PHP and its Sybase functions, as far as I can tell. Here is what the native data look like in MSSQL: Education & Technical Products Marketing Management Membership Legislative Issues Links & Resources News & Calendar Career Center Inside WTCA Affiliates Control Panel/Options Site Map and here is the output from PHP: Education & Technical Products & Tech Marketing& Techi Management Techia Membership Techia Legislative Issuesa Links & Resourcesa News & Calendarsa Career Centerrsa Inside WTCArrsa Affiliatesrrsa Control Panel/Options Site Mapanel/Op As you can see, it's adding characters from the previous row. The pattern is not perfectly consistent, however. We are currently using the dblib, and trying to configure ctlib, but aren't successful yet. Thank you for your time and attention. Jay Edgar ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15371&edit=1