> 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
If you define CLASS VARCHAR2(2000 CHAR) then you can insert 2000 chars
irrespective of their single- or multi- bytes.
a bit more
On 1/20/06, Wolfson Larry - lwolfs <lawrence.wolfson@(protected):
> Got an import from a client that kept getting
> IMP-00003: ORACLE error 1450 encountered
: maximum key length (6398) exceeded
> when creating index for table below.