Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unicode Character Allocation

Re: Unicode Character Allocation

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 18 Apr 2006 07:39:07 GMT
Message-ID: <1145345947.231492@proxy.dienste.wien.at>


Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

>> The CHAR option is the default so
>> most just use VARCHAR2(100).

>
> NO - Byte is default, CHAR must be specified!

If you do not change the configuration parameters, BYTE is indeed default. If you set NLS_LENGTH_SEMANTICS=CHAR, then CHAR will be default (after the next instance restart because of Bug 1488174).

Yours,
Laurenz Albe Received on Tue Apr 18 2006 - 02:39:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US