Can you have a Field Length more than 8000 characters

[CoolCoder]

Been reading lots on the web but no noe seems to know address this serious draewback of MS SQL server.

You simply cannot have a field with more than 8000 chars !

This is ridiculus. Access's "Memo" field type does it.

Any ideas ?

Tony
MarkNine Networks

http://www.marknine.co.uk

 

[swampBoogie]

Use text as datatype.

 

[SQLSister]

Or ntext if you need unicode data. You might also read up on how to insert and read data from these data types as it is different than other data types. READTEXT, UPDATETEXT and WRITETEXT are what you need to read up on.

 

[bertrandkis]

Read up about data types in the Books Online. The 8000 character is the size limit for varchar and Char Data type.
Use the Text data type for more characters.
Below is the definition of the Text data type.
Text:Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes.
Hope this Helps.

 

[tlbroadbent]

Tony,

You will discover that many of us will recommend reading the manual to learn the basics. The electronic documentation for SQL Server is called SQL Books Online or BOL. See the FAQ area of this forum for information about SQL BOL and other resources as well as SQLSister's excellent FAQ on recommended books. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[CoolCoder]

Thanks guys.

Problem Solved !