Type of field to create in forum table?

[N9ne]

I want to have a text area in each forum's edit/add screen. I know how to do that. I want to allow vbcode and htmlcode, I know how to do that too. One thing I don't know how to do or know if it's possible or not:

The field to create in the database...now a huge amount of text and code is to be entered into this text area and saved to the database, so i'm wondering, can a database store this much information? What query do I run to create the field? What details should the field hold? Type, size, etc. all that complicated stuff I never bothered to learn

[filburt1]

TEXT. IIRC it can store upwards of 65,536 characters.

Actually I was wrong: http://www.mysql.com/doc/en/Column_types.html. Use LONGTEXT for obscene amounts of text (4294967295 chars *falls out of chair*).

[N9ne]

Mega-cool, 4294967295 chars, I can work with that!

I'm running MySQL 4.0.11a on localhost, and I must say, it is great .

[Xenon]

mediumtext should be really enough for all

[N9ne]

What if some one has loads and loads of rules for a forum?

[Xenon]

hehe, i wan't to see the user which reads these rules completly and then registers

[N9ne]

Someone who has a lot of time on their hands .

[sparky2]

03-16-03 at 03:41 PM N9ne said this in Post #5
What if some one has loads and loads of rules for a forum?

then conserve database space by just storing a hyperlink in the field
(a link to an external rules page) :rambo:

[N9ne]

hehe, well I'm just trying to leave options open for users who install the hack I used the longtext in, just incase they want to put up some huge document in some forum before you can post a new thread .