MySQL Forums :: Database Design & Data Modelling :: physical bytes

Advanced Search

physical bytes
Posted by: Mirabell Stoffen ()
Date: September 07, 2011 02:03PM

If there is a column with data type varchar (10) so that max 10 characters can be stored in this column so it will take 11 bytes.

If there are many records with only 2 characters in that column.. then would it be taking 3 bytes in physical storage or its taking 11 bytes.

If it takes 11 bytes then what's the best practice to save the disk space?

Options: ReplyQuote

Subject Written By Posted
physical bytes Mirabell Stoffen 09/07/2011 02:03PM
Re: physical bytes Rick James 09/08/2011 08:30PM
Re: physical bytes Mirabell Stoffen 09/08/2011 10:30PM
Re: physical bytes Rick James 09/09/2011 06:27PM
Re: physical bytes Mirabell Stoffen 09/11/2011 12:18PM
Re: physical bytes Rick James 09/12/2011 11:22AM
Re: physical bytes Duncan Cox 09/13/2011 10:33PM

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.