PHP :: Bug #810 :: Problem with a ms-sql memo field

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

[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.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2024 The PHP Group All rights reserved.	Last updated: Sat Dec 21 12:01:31 2024 UTC