Question about VARCHAR and storage in design
I am making a smaller database (although this doesn't matter for my question) and I have added a "notes" field in most of the tables, so that notes can be stored about each row. I've defined the "notes" field as VARCHAR(255).
If someone doesn't enter a note, how much space does this take up? Is it only one or two bytes? (The name makes me thing that it only stores what is entered, plus a few bytes for control characters--such as line feeds and terminating characters).
I just want to make sure that if I have 1000 rows, for example, that I'm not wasting 256,000 bytes of blank data in the database.
Subject
Written By
Posted
Question about VARCHAR and storage in design
October 11, 2013 08:03AM
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.