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:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 8:02 AM
To: [EMAIL PROTECTED]
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       >> [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

Reply via email to