Printable View
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).
http://www.mysql.com/doc/en/Column_types.html
Has it all :)
That only tells me the sizes of the types.
Thats the only difference as far as I know. Bigger size, more memory.
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.Quote:
If so, what's the difference between that and VARCHAR
Alright. Thanks.