Skip navigation links

MySQL Forums :: Newbie :: TINY TEXT vs Varchar(240) and TEXT vs Varchar(300-500)


Advanced Search

TINY TEXT vs Varchar(240) and TEXT vs Varchar(300-500)
Posted by: Daniel Garcia ()
Date: March 24, 2009 06:18AM

Hi

im concerned about this since i have to make a table which contains arround 150 columns and the size per colum can vary alot but i calculate theres an average of 200 or 250 characters per colum, so i made research about mysql colum limit and for MyISAM the limit depends hugely on the lenght of the Varchars (lenght * 3) and every every table has a maximun of 65,535 bytes.

so i didnt made the table yet but, im sure it will fail cause the row size its gonna execed that.

now my question relating speed and storage space.

what are the adventages of using text and tiny text instead of varchars

will it be slower? or will it take more space on the database to store?

the tiny text looks fine since its maximun its 255 but the TEXT has a maximun 65535, so im concerned about how much space its gonna use this field. lets say...

i want to use a text field to store no more than 500 Bytes how much space ill take it on the database just 500 bytes? or will it take the whole 65535.

THX in Advance!

Options: ReplyQuote


Subject Written By Posted
TINY TEXT vs Varchar(240) and TEXT vs Varchar(300-500) Daniel Garcia 03/24/2009 06:18AM
Re: TINY TEXT vs Varchar(240) and TEXT vs Varchar(300-500) Rick James 03/25/2009 05:59PM
Re: TINY TEXT vs Varchar(240) and TEXT vs Varchar(300-500) Daniel Garcia 03/26/2009 08:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.