data

I am making a web site of a magazin and when i try to store data in the tabl
e
,the data was larger . and i asked how can i store the large text in the
table and if it possible to store text file?how can i store the large text
--See my previous post on your thread for storing text.
As long as the text is less than 8000 bytes you can use varchar
(nvarchar(4000)). For a size above this limit
you can use TEXT (2^31 - 1 (2.147.483.647) bytes or 2^30 - 1 (1.073.741.823)
bytes -->NTEXT.
-store text file
You are able to store binary data, such as files:
"Generally speaking, you use text to store huge ASCII character strings,
ntext for Unicode character strings, and image for binary image data. "
It can store up to (2^31 - 1 (2.147.483.647) bytes .
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Zoza" <Zoza@.discussions.microsoft.com> schrieb im Newsbeitrag
news:DD62FB13-CB0A-4A8C-A946-84D1ACA5A8F7@.microsoft.com...
>I am making a web site of a magazin and when i try to store data in the
>table
> ,the data was larger . and i asked how can i store the large text in the
> table and if it possible to store text file?|||Thanks
I really try to use txt and ntxt to specify the type of data ,but when i try
to store data it was very large.
I want to make a table of news that contain title of news and the details of
news ,no problem of storing title,but the details of news was no longer.
I can't know what i do?
"Jens Sü?meyer" wrote:

> how can i store the large text
> --See my previous post on your thread for storing text.
> As long as the text is less than 8000 bytes you can use varchar
> (nvarchar(4000)). For a size above this limit
> you can use TEXT (2^31 - 1 (2.147.483.647) bytes or 2^30 - 1 (1.073.741.82
3)
> bytes -->NTEXT.
> -store text file
> You are able to store binary data, such as files:
> "Generally speaking, you use text to store huge ASCII character strings,
> ntext for Unicode character strings, and image for binary image data. "
> It can store up to (2^31 - 1 (2.147.483.647) bytes .
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Zoza" <Zoza@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:DD62FB13-CB0A-4A8C-A946-84D1ACA5A8F7@.microsoft.com...
>
>|||Was the data tool arge for the ntext / text column. I wonder that if so any
human would ever read this article containing more than 2^31 bytes ? Or what
did you want to say with "it was very large".
And what does "details of news was no longer" mean ?
Jens Suessmeyer.
"Zoza" <Zoza@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F8DA783D-0A94-4347-AE48-72E96E8628CC@.microsoft.com...
> Thanks
> I really try to use txt and ntxt to specify the type of data ,but when i
> try
> to store data it was very large.
> I want to make a table of news that contain title of news and the details
> of
> news ,no problem of storing title,but the details of news was no longer.
> I can't know what i do?
> "Jens Smeyer" wrote:
>