Kbase P53202: Inserting LVARBINARY data > 32K fails with error in 9.1D07
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Inserting LVARBINARY data > 32K fails with error in 9.1D07
[JDBC Progress Driver]:Character string is to long (8184)
CAUSE:
LVARBINARY column was created without specifying the length:
create table blobtest
(
FILENAME VARCHAR(30),
FILEDATA LVARBINARY,
FILESIZE NUMBER
)
FIX:
Create the LVARBINARY column by specifying the max. length, example:
create table blobtest
(
FILENAME VARCHAR(30),
FILEDATA LVARBINARY(100000),
FILESIZE NUMBER
)