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 Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
27 + 32 = ?
Subscribe to this entry?

 
 [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-2024 The PHP Group
All rights reserved. 		Last updated: Tue Apr 23 10:01:29 2024 UTC