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

Gints Plivna <gints.plivna_at_gmail.com> 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!

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