Jump to content

TEXT vs VARCHAR


terryds
 Share

Recommended Posts

Here's a list of the data types and their storage requirements:

 

http://dev.mysql.com/doc/refman/5.6/en/storage-requirements.html

 

You can give a varchar column any size, but it is limited by the maximum size of a single row of data (including all columns), which is 64KB. Text columns do not add to the maximum row size, because the actual text is not stored with the rest of the row.

 

There's a description of the text and blob types here, with differences between that and varchar:

 

http://dev.mysql.com/doc/refman/5.6/en/blob.html

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...