Re: char vs varchar2
Date: 1999/12/20
Message-ID: <83lcn9$tba$1_at_nnrp1.deja.com>#1/1
Hi,
char is a fixed-length datatype.
[Quoted] if you have rows that need less than the max size you defined in the
[Quoted] [Quoted] database, they will be right-padded with blanks.
[Quoted] Varchar2 is a true varying lenght type - no padding.
[Quoted] [Quoted] char is rarely used - in general you should use varchar2.
Karsten
[Quoted] In article <83kcr6$8lj$1_at_nnrp1.deja.com>,
marcus_chan_at_my-deja.com wrote:
> hello,
>
> hope someone could enlighten me on these?
> 1. What are the diffrences between Char/varchar2?
> 2. When should i use char/varchar2 in table creation?
>
> thanks
> marcus
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Dec 20 1999 - 00:00:00 CET