hi every one,
I am going to design e commerce site.If 1 user enter into the site..i have to allow them to write the COMMENTS about product..So i want to design a database(SQL SERVER 2000),but...for comments ..which datatype should i use...varchar is enough?And should i store about all the information of each user?
Thanks in asvance.

It depends. Are you going to limit the max comment size to say, 4000 characters, or are you going to allow the user to type to their hearts content?

In either case, a varchar field has a max length of 8000(less than 1mb) bytes where as a text field has a max length of 2,147,483,647 bytes (about 2147mb)

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========