Very Computer

by **Bill** » Wed, 30 May 2001 23:02:16

with SQL 2000, is it possible to create a datatype over 8000 characters? I need
to store and retrieve user stories that could be up to 1200 characters. I would
rather keep them in the database instead of storing them as flat text files and
then pointing to them from the database.

by **Douglas Reill** » Wed, 30 May 2001 23:07:24

the text data type, though there are some gotchas involved with this using
this data type. See Books OnLine.

BTW, 1200 is less than 8000.

with SQL 2000, is it possible to create a datatype over 8000 characters? I
need
to store and retrieve user stories that could be up to 1200 characters. I
would
rather keep them in the database instead of storing them as flat text files
and
then pointing to them from the database.

by **bill** » Wed, 30 May 2001 23:26:20

oops, I meant to say 12,000 characters, I noticed that the text datatype only
gives me up to 4000, the varchar 8000.

Quote:-----Original Message-----
with SQL 2000, is it possible to create a datatype over 8000 characters? I need
to store and retrieve user stories that could be up to 1200 characters. I would
rather keep them in the database instead of storing them as flat text files and
then pointing to them from the database.
.

by **Andrew J. Kell** » Wed, 30 May 2001 23:31:38

Bill,

4000 is for an nVarchar datatype. TEXT will give you up to 2GB.

--
Andrew J. Kelly, SQL Server MVP
Targitmail

oops, I meant to say 12,000 characters, I noticed that the text datatype
only
gives me up to 4000, the varchar 8000.

Quote:-----Original Message-----
with SQL 2000, is it possible to create a datatype over 8000 characters? I
need
to store and retrieve user stories that could be up to 1200 characters. I
would
rather keep them in the database instead of storing them as flat text files
and
then pointing to them from the database.
.

Very Computer

creating a large datatype (over 8000 characters)

creating a large datatype (over 8000 characters)

creating a large datatype (over 8000 characters)

creating a large datatype (over 8000 characters)

creating a large datatype (over 8000 characters)