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: Multi-byte databases.

Re: Multi-byte databases.

From: K POON <kspoon_at_netvigator.com>
Date: Tue, 06 Oct 1998 21:32:03 +0800
Message-ID: <361A1BD3.756C7207@netvigator.com>


Hi,

The definition of VARCHAR2 shows

VARCHAR2(size), Variable length character string having maximum length size bytes. Maximum size is 2000, and minimum is 1.

Hence 32 bytes or 16 double-bytes character.

Regards,
K POON Julian Hare wrote:

> Hi,
>
> I need clarification on my understanding of how how multi-byte NLS
> works. If I create a database with a character set of ZHT16BIG5 (BIG5
> Traditional Chinese), and I create a table with a field description of:
> NAME VARCHAR2(32)
> Can I enter 32 characters into this field, or only 16?
>
> Thanks in advance.
> julian.
Received on Tue Oct 06 1998 - 08:32:03 CDT

Original text of this message

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