tinytext vs char??

[szym9341]

I am working on creating a column in a table... the column will contain a few sentences. What is the difference between storing the data in a char(200) or tinytext?

thanks.

[rgermain]

When using char it paddes the left over space with spaces.

Like if you were to use char(10) then lets say you insert "mySQL" you will have mysql with 5 spaces afterwards.

tinytext() and varchar() do not pad and serve the same purpose.

From the way it sounds I would recommend using either tinytext() or varchar(). I guess it all depends on what you are using it for.