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

Written By
physical bytes
September 07, 2011 02:03PM
September 08, 2011 08:30PM
September 08, 2011 10:30PM
September 09, 2011 06:27PM
September 11, 2011 12:18PM
September 12, 2011 11:22AM
September 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.