php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2020 The PHP Group
All rights reserved.
Last updated: Sun Nov 29 20:01:26 2020 UTC