 | |
i can't insert 'a''a' in a field with size 3
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: i can't insert 'a''a' in a field with size 3 -
03-11-2008
, 03:34 AM
|
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. |
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
#12
| |||
| |||
|
|
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. |
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
#13
| |||
| |||
|
|
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. |
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
#14
| |||
| |||
|
|
Gints Plivna <gints.plivna (AT) gmail (DOT) 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 |
table created as
create table(field varchar2(1 char) 3 or 4 for the column length
(depending on characterset). So, the first thing i would ask - how did
OP come to the conclusion, that field has size 3...
Best regards
Maxim
#15
| |||
| |||
|
|
Gints Plivna <gints.plivna (AT) gmail (DOT) 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 |
table created as
create table(field varchar2(1 char) 3 or 4 for the column length
(depending on characterset). So, the first thing i would ask - how did
OP come to the conclusion, that field has size 3...
Best regards
Maxim
#16
| |||
| |||
|
|
Gints Plivna <gints.plivna (AT) gmail (DOT) 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 |
table created as
create table(field varchar2(1 char) 3 or 4 for the column length
(depending on characterset). So, the first thing i would ask - how did
OP come to the conclusion, that field has size 3...
Best regards
Maxim
#17
| |||
| |||
|
|
Gints Plivna <gints.plivna (AT) gmail (DOT) 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 |
table created as
create table(field varchar2(1 char) 3 or 4 for the column length
(depending on characterset). So, the first thing i would ask - how did
OP come to the conclusion, that field has size 3...
Best regards
Maxim
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.