php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #15619 odbc_result() doesn't return ms sql server text field correctly
Submitted: 2002-02-19 06:52 UTC Modified: 2002-04-26 10:29 UTC
Votes:2
Avg. Score:4.0 ± 1.0
Reproduced:2 of 2 (100.0%)
Same Version:1 (50.0%)
Same OS:2 (100.0%)
From: ed at whisk dot nildram dot co dot uk Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.1.1 OS: Win2k Pro/Adv Server
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: ed at whisk dot nildram dot co dot uk
New email:
PHP Version: OS:

 

 [2002-02-19 06:52 UTC] ed at whisk dot nildram dot co dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-02-19 10:49 UTC] kalowsky@php.net 
Is your text field of type 'ntext'?
 [2002-02-19 11:12 UTC] ed at whisk dot nildram dot co dot uk 
No - this is with text type fields.  I just tried it with ntext and php just crashes.  (using mssql functions text works fine and ntext gives an error todo with unicode).

I'm using the isapi dll btw.
 [2002-02-28 04:55 UTC] ag at aloha-systeme dot de 
The Problem is also there with text fields and Informix 7.2 (Sparc). We tried the generic ODBC Drivers and the Merant Drivers (Ad. W2k Server, Apache, PHP 4.1.1).
It must be a general problem with text-fields.

Selecting only other than text colums will go around the problem. 

Alex
 [2002-04-26 10:29 UTC] kalowsky@php.net 
TEXT field is not a proper/valid format for data in ODBC v2.0 (which is what PHP uses).  This is why it doesn't work.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sat Nov 29 04:00:01 2025 UTC