ID: 15619
Updated by: [EMAIL PROTECTED]
-Summary: odbc_result() doesn't return ms sql server text field
correctly
Reported By: [EMAIL PROTECTED]
-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] [EMAIL PROTECTED]
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
