volume of data

agmorgan

I am reasonably new to programming so please be gentle

I am trying to create a facility in my program that allows for a diary relating to some jobs that I am doing. The diary requires a notes facility which i though would be easy by writing

echo "<textarea name='Note' value='$Note' rows='3' cols='80'></textarea>";

and then saving the $Note into a database.

however the Database restricts me to 255 characters. the error mesage then says use BLOB..

I am now posting this query which well over 255 characters,

Obviously I am going about this the wrong way can anyone point me in the write direction and what is BLOB..

matchew

youre limited to 255 characters if you set the field to varchar set it to longtext or blog and you'll be unrestricted

agmorgan

How do I keep the formating ?

agmorgan

matchew wrote:
youre limited to 255 characters if you set the field to varchar set it to longtext or blog and you'll be unrestricted

Appreciated.. Can you let me know how you can keep the formating ?

cheers

thorpe

What do you meen by keep the formatting? If you need to store more than 255 characters in a database filed you will need to make it of the type TEXT not VARCHAR.

Sxooter

You're probably talking about how the text from the text box doesn't keep it's formatting when you just display it on the screen.

Well, it's not HTML, it's just text, so of course, carriage returns don't mean anything to formatting html.

look up the function nl2br() in the docs and see if that helps.