If you're using LONGTEXT, you don't get a choice of lengths. You can use TINYTEXT, TEXT, MEDIUMTEXT, or LONGTEXT to select different sizes (up to 2^8, 2^16, 2^24, and 2^32 chars respectively), but that's it. TINYTEXT takes the length of the string to store plus one byte. Text takes length + two bytes. It's +3 and +4 for MEDIUMTEXT and LONGTEXT, respectively.
cheers, barneyb On 11/11/05, Ray Champagne <[EMAIL PROTECTED]> wrote: > So, I'm building a little mini-CMS for my own personal use here, and am > using MySQL as the DB backend. I am going to be storing page content in > a longtext field (it will be strictly HTML inserted by fckeditor), but I > have no idea how long to make the field. I see that the max size is > 4294967295 characters, but I've seen ppl use multiples of 512 in this > field when checking other sites that I am modeling after. First off, > why is this? Second, what is a good suggested size to set this field at? > > Hopefully someone's up at this hour on a Friday, and I'm not the only > one all geeked-up right now. > > Thanks, > > Ray > -- > ============================== > Ray Champagne > Application Developer > CrystalVision Web Site Design > http://www.crystalvision.org > 603.433.9559 > [EMAIL PROTECTED] > ============================== > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224017 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
