Variables - setting type

[Modern Merlin]

I have searched all over the web and found many conflicting answers to the question I am about to ask. I am asking here because I have always gotten the most straight forward responses through this site.

I have a form, through which one field is a text box. In this field several people are going to be adding notes. Obviously if I declare the variable for that field a varchar it has a limit of 255 characters (to my understanding anyways).

What I want to know is... Is there another variable type that I can declare this variable so that should 3 people update this field and need 500 Characters it will save it to the database? Or is 255 the limit?

Thanks!

Modern Merlin

[Habtom]

I would suggest you use the type "TEXT" instead of "VARCHAR" in this case.

[edited by: Habtom at 5:14 am (utc) on Dec. 27, 2007]

[Modern Merlin]

And is there a limit on how many characters you can have with Text?

[Habtom]

Yea somewhere around, 2^16 -1, which makes it way beyond the required size by your input box.

[Modern Merlin]

THANK YOU SO MUCH! You just completely fixed my problem!