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?

Fici wrote:
SQL> create table test (
2 field1 VARCHAR2(3));

Table created.

SQL> INSERT INTO test
2 (field1)
3 VALUES
4 ('a''a');

1 row created.

SQL> SELECT * FROM test;

FIE
---
a'a

SQL>

try the following in SQL*Plus:

show define

Post the result

If you are not using SQL*Plus then your front-end tool is
defective or needs to be reconfigured.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Fici wrote:
SQL> create table test (
2 field1 VARCHAR2(3));

Table created.

SQL> INSERT INTO test
2 (field1)
3 VALUES
4 ('a''a');

1 row created.

SQL> SELECT * FROM test;

FIE
---
a'a

SQL>

try the following in SQL*Plus:

show define

Post the result

If you are not using SQL*Plus then your front-end tool is
defective or needs to be reconfigured.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Fici wrote:
SQL> create table test (
2 field1 VARCHAR2(3));

Table created.

SQL> INSERT INTO test
2 (field1)
3 VALUES
4 ('a''a');

1 row created.

SQL> SELECT * FROM test;

FIE
---
a'a

SQL>

try the following in SQL*Plus:

show define

Post the result

If you are not using SQL*Plus then your front-end tool is
defective or needs to be reconfigured.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Fici wrote:
SQL> create table test (
2 field1 VARCHAR2(3));

Table created.

SQL> INSERT INTO test
2 (field1)
3 VALUES
4 ('a''a');

1 row created.

SQL> SELECT * FROM test;

FIE
---
a'a

SQL>

try the following in SQL*Plus:

show define

Post the result

If you are not using SQL*Plus then your front-end tool is
defective or needs to be reconfigured.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Mar 10, 6:38 pm, Fici <moretto.feder... (AT) gmail (DOT) com> wrote:
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
http://www.gplivna.eu

On Mar 10, 6:38 pm, Fici <moretto.feder... (AT) gmail (DOT) com> wrote:
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
http://www.gplivna.eu

On Mar 10, 6:38 pm, Fici <moretto.feder... (AT) gmail (DOT) com> wrote:
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
http://www.gplivna.eu

On Mar 10, 6:38 pm, Fici <moretto.feder... (AT) gmail (DOT) com> wrote:
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
http://www.gplivna.eu

Gints Plivna <gints.plivna (AT) gmail (DOT) com> wrote:
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