Maximum number of characters in a database table field

[bevans]

Can any one help me, i'm building a dynamic database driven site using dreamweaver and MS SQL2000 andi'm haveing problem storing over 8000 characters in a table filed (IE: it wont let me!!) is there a special table field value that i need to set to get more characters in a table field or is this a limitation of SQL.

Any help or suggestions would be appreciated

Regards
B

[Markus]

Columns of char datatype have a maximum lenght of 8060. If you need to store more you have to use text or ntext as datatype. See BOL

[bevans]

Cheers Markus much appreciated

will try that,

Regards

Brian

[ravinder_k]

Note that text field has no mercy when it comes to using it in stored procedures. Its not as flexible as varchar fields. So if you could use multiple varchar fields and somehow manage to concatinate them in your front end code, pls do that.