5k of data is way too much for varchar, so i would use a field of type TEXT.
i do this as well (storing html data in mysql) and it works great. some say
to use addslashes() although, on my setup (3.23/4.1) it seems to addslashes
automatically - not sure exactly why that is though.
From: mike karthauser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 8:02 AM
To: [EMAIL PROTECTED]
Subject: inserting html into mysql tables
is there anything special i need to know in regards to creating a table to
hold html data? I am building a CMS for a site using php and mysql. The
various tables hold course information that the client wants to edit. I
imagine it will be a case of dropping the cleaned html source from
dreamweaver into a form box and posting it to the table.
What would a good varchar(?) be for say 5K of data?
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
07939 252144 (mobile)
Snailmail >> Unit 8, 14 King Square,
Bristol BS2 8JJ
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php