The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Now for the question. Should I use the varchar data type for everything, since each field could vary in length except for index. Also is there a difference between mediumblob and medium text. I was going to go with blob, but one page is 65K characters (terms and conditions page).

I was reading varchar can slow down things and if i go with mediumblob to accomodate one page will that slow things down? All in all there will be about 5 tables that will be used to generate 50 or so pages.

what sort of values were you thinking of putting into the "index" field?

make the datatypes VARCHAR(255), except for the one which will hold your content

according to the mysql manual,

The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive fashion for BLOB values and case-insensitive fashion for TEXT values. In other words, a TEXT is a case-insensitive BLOB.

use as few BLOB/TEXT columns as you can get away with

the keywords is potentially another problem -- if you were thinking of storing comma-delimited words in there, don't, set up a separate 1-to-many table

One more thing. I think I may change the way I lay out my tables. Initially I was going to have one table for each section of my website for a total of about 5 tables. Each table would have had the same values, but now i am thinking I should just use one or two.

I will call a page with the PageID variable, the page that matches will use all the data in the given row. Then a menu will be built, which may use parentID, Title, PageID and URL. All the other fields will be unused.