Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

choice of length of a varchar

427838Jul 7 2005 — edited Jul 11 2005

Hi,
I would like to know if the choice of a length of a field when creating a table will influence the space of the database?
By example, if I know that I will only have strings of max 20 chars and I create a field with varchar2(255) rather than varchar2(20) in a table. Will it influence the database size on disk if I enter a lot of entries?

Thank you,
Mathieu

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2005

Added on Jul 7 2005

#general-database-discussions

5 comments

1,302 views