if you use the PHP MSSQL driver, find a line in php.ini : mssql.textlimit = 4096 mssql.textsize = 4096 and change there are value to you wanted. elman 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 > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
