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

go to bug id or search bugs for

Bug #810 Problem with a ms-sql memo field
Submitted: 1998-10-02 12:26 UTC Modified: 1998-11-03 20:59 UTC
From: seban at dungeon dot de Assigned:
Status: Closed Package: Sybase (dblib) related
PHP Version: 3.0.4 OS: linux/sparc-solaris
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: seban at dungeon dot de
New email:
PHP Version: OS:

 

 [1998-10-02 12:26 UTC] seban at dungeon dot de 
I'm running php 3.0.4 as an apache module (1.2 and 1.3) with the
subase-ct lib(linux) or the sybase-db lib(solaris) and i have the following
problem.

ms-sql db on a nt-server with a memo field.


i can write data into the field but if i want to read them  via

 $res = mssql_query("select * from DB",$conn);
 mssql_result($res,0,3)    // its the 4th field...

i get just the first 4kb data... 

but if i use MS-Access to view the Database via ODBC i can see that 
everything is there... so only the read doesnt work... 


can u help me ?


thx 
sebastian

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1998-11-03 20:59 UTC] tommay 
This is not related to PHP, but appears to be a problem
with the Sybase libraries or, more probable, a limitation
(possibly changable one?) in Microsoft SQL.

Real answer:  That is standard behavior for sybase and mssql server 
You need to execute the sql command "set textsize 65536"
after opening the connection - Tom.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 17:01:58 2024 UTC