Re: i can't insert 'a''a' in a field with size 3

From: Gints Plivna <>
Date: Mon, 10 Mar 2008 13:21:18 -0700 (PDT)
Message-ID: <>

On Mar 10, 6:38 pm, Fici <> wrote:
> hi,
> i run
> INSERT INTO test (FIELD1) VALUES ('a''a')
> but DBMS oracle returns this error:
> ORA-01401: inserted value too large for column
> (FIELD1 size is 3!)
> what's the error?

Might be one of unicode charsets having each symbol more than one byte and column size defined in bytes not chars. Check DB charset and whether column is defined as char or byte.

Gints Plivna Received on Mon Mar 10 2008 - 15:21:18 CDT

Original text of this message