Picking a column type for text size?

[random1]

I am currently using VARCHAR(255) for some text fields in my database.

 

I have a  few fields like:

 

• page_title

- should be max 50 characters long

• page_content

- should be as long as possible

• page_keywords

- should be max 100 characters long

 

Should I be using CHAR or TEXT instead for these fields?

 

I am trying to improve performance and data integrity.

[premiso]

page_title I would do a varchar(50) As it is not a set width, like a password hash would be. IE: If you know how long  the string has to be no more no less, use Char. If it can var, use VARCHAR.

 

page_content it depends on your need, it can be clob / text / bigtext etc. Read up on them and determine which is right for you.

 

Page_keywords, save as title, varchar(100) since it can be anything from 0-100.