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

From: Laurenz Albe <>
Date: 11 Mar 2008 09:34:03 GMT
Message-ID: <>

Gints Plivna <> wrote:
>> 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.

Not in this case. Both "a" and "'" are only one byte long in UTF-8, and UTF-16 is not a valid database character set.

But you are right that a weird character set might be at fault!

Laurenz Albe Received on Tue Mar 11 2008 - 04:34:03 CDT

Original text of this message