Re: CHAR v. VARCHAR2: Space or Performance Optimization

Eric A. Stephens wrote:
>
> We are designing a fairly large DB and have concluded that using
> VARCHAR2 for all character data is acceptable since Oracle needs
> to store some data length information in each row piece in the
> data blocks.
>
> Is this a correct assumption?

Do it. You won't regret it. A lot of stuff can act wierd if the character data is stored as a CHAR instead of a VARCHAR2 - applications built in Developer 2000's Forms 4.5 for one.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||