Re: Something easy? ORA-01450: maximum key length (6398) exceeded
- From: Gints Plivna <gints.plivna@xxxxxxxxx>
- To: lawrence.wolfson@xxxxxxxxxx
- Date: Fri, 20 Jan 2006 11:13:19 +0200
> Just wondering what did the CHAR attribute do for them?
> Or rather what did I lose?
One character generally can take 1 or more bytes
If you define CLASS VARCHAR2(2000) which is equivalent to CLASS
VARCHAR2(2000 BYTE) you can store up to 2000 single-byte characters or
less multi-byte characters mixed with single-byte characters. For
example you cannot insert 1999 single-byte caharacters and 1
multi-byte character.
If you define CLASS VARCHAR2(2000 CHAR) then you can insert 2000 chars
irrespective of their single- or multi- bytes.
Gints
a bit more
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adfnstyp.htm#424673
On 1/20/06, Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx> wrote:
> Got an import from a client that kept getting
>
> IMP-00003: ORACLE error 1450 encountered
> ORA-01450: maximum key length (6398) exceeded
>
> when creating index for table below.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
