Thanks Barney. After I posted this, I noticed that even though I could specify the length when creating the field, when I saved the table, it reverted back to the default. Guess I should have tried that first.
Thanks for the other info, that is very helpful. Ray Barney Boisvert wrote: > 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:224033 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
