[Resolved] MySQL: TINYTEXT, MEDIUMTEXT, LONGTEXT...

[The Hobo]

What's the difference, besides size, in all of these? Is there any drawbacks to using them?

If I know that a field will never have more than 500 characters, should I then use MEDIUMTEXT? Would it use up more memory to just go with TEXT?

In fact, what are the sizes? I think TINYTEXT is 255. If so, what's the difference between that and VARCHAR (since it can go up to 255).

[Chroder]

http://www.mysql.com/doc/en/Column_types.html

Has it all

[The Hobo]

That only tells me the sizes of the types.

[Chroder]

Thats the only difference as far as I know. Bigger size, more memory.

If so, what's the difference between that and VARCHAR

VARCHAR takes one byte more then the amount of characters being stored. If you have a 3 character string, it takes up 4 bytes etc. If you were to store the a 1 character string in a char(4), it would take 4 bytes while if it was in a varchar(4), it would only take 2 bytes.

[The Hobo]

Alright. Thanks.