Re: Oracle accent

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 24 Apr 2007 02:47:27 -0700
Message-ID: <1177408047.286637.209360@u32g2000prd.googlegroups.com>

boutreau.adrien_at_gmail.com wrote:
> HI
>
> I'm trying to insert into
>
> ACC_REF VARCHAR2(20 BYTE),
>
> this value : "0123456789012346éaé" (french accent) and i've got this
> error :
> 'ORA-01401: ' value is too big. I know the problem with oracle, and if
> I modify the number of byte the problem is resolved. But, is it
> possible to format the string before inserting into oracle and not
> modifying the number of byte ?
>
> Thanks to read me!

The problem most probably is that your french characters take more than one byte i.e. these are multibyte characters. You have to either 1) choose another characterset of the db so that your french characters are not multi-byte (which actually means rebuild the DB, actually just a theoretical solution ;)
2) change VARCHAR2(20 BYTE) to VARCHAR2(20 CHAR), so that oracle takes more space for this particular column, but you definitely can store 20 characters not only 20 bytes.

Gints Plivna
http://www.gplivna.eu Received on Tue Apr 24 2007 - 04:47:27 CDT