Re: Retrieving "text" > 4K SQL Server 7.0

I found my answer! The PHP.INI file sets "odbc.defaultrl = 4096". Setting this to 0 removes any size limitation (passthru). However, while SQL Server gladly accepted 710K from a form textarea, PHP did nasty things when it tried to put 710K into a string variable [$s_description = odbc_result ($resultset, "f_description");] I found that I can use 128K (odbc.defaultrl = 131072) without any problems, and for my purposes, that should be sufficient. -Al On Wed, 15 Aug 2001 15:26:45 GMT, al@xZty321.com (Al) wrote: >Setup: PHP 4 and Apache on NT 4; SQL Server 7.0 on NT 4, Unified ODBC >using SQL Server ODBC driver. > >How does one go about getting "text" data out of SQL Server 7.0 using >PHP's Unified ODBC drivers? This is "text" data... not varchar()! > >I can PUT as much data as I want into a "text" column in a table, but >I can only GET 4096 bytes in a SELECT. > >Reading the SQL 7.0 docs, it says 4K is the default amount of data >that's allowed in a SELECT statement. However, the same docs say that >when using ODBC, the driver sets it to return the max allowed for the >machine (~2GB). > >I can whip up a Delphi app to use the same ODBC DSN and pull all the >"text" data out of the column, but I just can't get it to work using >PHP. I realize there's lots of hidden stuff in Delphi's BDE, so I know >that's not a valid comparison. > >I've also tried using the PHP MSSQL drivers and I get the same >results, so I'm sure there's something I'm missing on the SQL Server >7.0 end. > >Help?!?! > >-Al