SQL Server 7 help needed!!!
| From: | Romulo Roberto Pereira | Date: | Wed, 03 Jan 2001 18:13:29 +0000 |
| Subject: | SQL Server 7 help needed!!! | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-4765@lists.php.net to get a copy of this message | ||
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