Kbase P7640: Inserting Data into a VARCHAR field using a SQL-92 client fails with error (8184)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/11/2008 |
|
Status: Verified
SYMPTOM(s):
Inserting Data into a VARCHAR field using a SQL-92 client fails
[JDBC Progress Driver]:Character string is to long (8184)
FACT(s) (Environment):
Progress 9.1x
CAUSE:
Code which causes the error:
create table pub.test (id INTEGER, test VARCHAR);
commit;
insert into pub.test
values(123,'asdfasdfasdfasfasdfasf');
FIX:
Code which works fine:
create table test2 (id INTEGER, test VARCHAR(80));
commit;
insert into test2
values(123,'asdfasdfasdfasfasdfasf');
According to paragraph 2.3.1 in the 9.1D Dynatext, the default length of VARCHAR
is 1. The number in () represents what the length is limited than.