Re: SQL Server 7 help needed!!!

You can change the size of text columns returned from a SELECT statement by altering the settings of mssql.textsize and mssql.textlimit in you php.ini file. If the two values is undefined in php.ini the library uses the default settings from your server. - Frank >Hello!!! > >I am using a PHP4/2000 Server/IIS/MsSQL solution. > >I create a simple table to store some news: > >CREATE TABLE [dbo].[news] ( > [newsID] [int] IDENTITY (1, 1) NOT NULL , > [priority] [char] (1) NULL , > [text] [text] NULL , > [title] [char] (50) NULL , > [startdate] [datetime] NULL , > [enddate] [datetime] NULL , > [headline] [char] (400) NULL , > [link] [char] (250) NULL >) > >It is the filed named text that I am talking about. > >On the SQL manual says that the text field can hold an impressive amount of data but on my case >is only holding 8Kb. what is correct because SQL 7automatically breaks in 8K chunks. But what is >happenning is when I do a select to bring the data is only bring the 8K > >Please, I need help? > >Rom > >