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. -----Original Message----- From: mike karthauser [mailto:mikek@brightstorm.co.uk] Sent: Thursday, November 21, 2002 8:02 AM To: php-db@lists.php.net Subject: inserting html into mysql tables hi, 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? cheers mikek -- Mike Karthauser Managing Director - Brightstorm Ltd Email >> mikek@brightstorm.co.uk 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
