Choosing correct MYSQL column type

Forum Moderators: open

Message Too Old, No Replies

2:17 am on Feb 28, 2007 (gmt 0)

Hi guys,

I am setting up tables to store data sent from FCKeditor.
What type of column am I best to use for storing the html code?

3:59 am on Feb 28, 2007 (gmt 0)

probably "longtext"

5:24 am on Feb 28, 2007 (gmt 0)

HI phranque,

Would longtext be better than TEXT?

8:27 am on Feb 28, 2007 (gmt 0)

text is good for up to about 2**16 or approximately 64K.
longtext is good for about 2**32 or approximately 4M.

it just depends on how limited you want to be for the length of the text string...