Bug #15619 Updated: odbc_result() doesn't return ms sql server text field correctly

ID: 15619 Updated by: kalowsky@php.net -Summary: odbc_result() doesn't return ms sql server text field correctly Reported By: ed@whisk.nildram.co.uk -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: Win2k Pro/Adv Server PHP Version: 4.1.1 New Comment: Is your text field of type 'ntext'? Previous Comments: ------------------------------------------------------------------------ [2002-02-19 06:52:40] ed@whisk.nildram.co.uk Using odbc functions with MS SQL Server 2k, using odbc_exec() with a select query to fill a result set. Fields of type varchar are returned successfully, but text fields behave strangely. When doing: $someField = odbc_result($resID, "textField"); the value of the field seems to be echoed, and $someField is given the value '1'. Changing the field type to varchar in SQL Server (and changing no php code), it returns to the expected behaviour (value of the field assigned to $someField). I've got the same behavior on 2 different installs of php, one running w2k pro with local sql server and one w2k adv server and remote sql server. Ed Eastman ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15619&edit=1