Re: char vs varchar2

In article <83re7n$70d$1_at_nnrp1.deja.com>,   amehta2000_at_my-deja.com wrote:
> Hi!
>
> 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?
> > > > 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 --
>

I am not sure about double byte character sets, but I believe that the datatypes char and varchar2 both still work as normal, but that you have to account for the number of bytes instead of characters, that is, a five character long char or varchar datatype would be declared as 10 bytes to hold the data.

The documentation for this should be in the Concepts manual chapter on datatypes and in the Application Developers Guide. Oracle provides special datatypes NCHAR and NVARCHAR2 for working with multi-byte character sets.

--
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. Received on Thu Dec 23 1999 - 11:55:13 CST