Skip to Main Content

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Varchar2 lengths

John_KFeb 13 2018 — edited Feb 14 2018

This is more of a discussion out of interest rather than an issue I am having... I see many developers when creating tables use base 2 lengths for varchar2 columns. I've always been a believer in the right size for the job, however I'm interested into where this has come from. I.e. a column is needed to store a descriptive piece of text. About 30 characters. However - they will instead use Varchar2(32). Need something a bit longer - it of course is a varchar2(128) or similar!

Is there any logic in this at all? I presume no storage gain, as the strings are variable length. Or is it just developers like to think in base 2?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 14 2018
Added on Feb 13 2018
24 comments
4,435 views