Re: char vs varchar2
Date: 1999/12/22
Message-ID: <83re7n$70d$1_at_nnrp1.deja.com>#1/1
Hi!
[Quoted] How does Oracle handle Double-Byte Character Sets? For multilingual support, specifically for Double Byte Character Sets, can I still use CHAR to store a single character. The default size of CHAR is 1 byte..will this allow me to store special characters (such as Chinese letters) that require double-byte character sets?
In article <83leur$v0f$1_at_nnrp1.deja.com>,
markp7832_at_my-deja.com wrote:
> In article <83lcn9$tba$1_at_nnrp1.deja.com>,
> karsten_schmidt8891_at_my-deja.com wrote:
> > Hi,
> >
> > char is a fixed-length datatype.
> > if you have rows that need less than the max
size you defined in the
> > database, they will be right-padded with
blanks.
> > Varchar2 is a true varying lenght type - no
padding.
> >
> > char is rarely used - in general you should
use varchar2.
> >
> > Karsten
> >
> > 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?
[Quoted] > > > 2. When should i use char/varchar2 in table
creation?
> > >
> > > thanks
> > > marcus
> > >
> I agree use varchar2. Look at Oracle's
dictionary and Oracle
> products. They use varchar2 even for one byte
columns.
>
> --
> Mark D. Powell -- The only advice that counts
is the advice that
> you follow so follow your own advice --
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Dec 22 1999 - 00:00:00 CET