[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Use of Sybase text datatype is recognized as char datatype!
- Subject: Use of Sybase text datatype is recognized as char datatype!
- From: "Simonian, Guy" <SimonianG@AETNA.COM>
- Date: Fri, 3 Apr 1998 13:44:16 -0500
Am trying to write to a Sybase "text" datatype which is supposed to hold
up
to 2 gig of ascii data, yet the errors I get indicate that Sybase thinks
its getting char data;
begin-setup
begin-sql on-error=SKIP
create table {DETAILDB} (out_line text null)
end-sql
end-setup
begin-procedure main
let $abc = '1234567...300 characters of data....'
begin-sql
insert into {DETAILDB} (out_line) values ($abc)
end-sql
end-procedure
-------When I run this, I get the following bind errors. It looks like
SQR is passing char data, even though the field is defined as type
text.:
--------------------------
(SQR 5528) Sybase dbbind: ct_param error in cursor 119:
(138) ct_param(): user api layer: external error: A data length of
300 exceeds the maximum length allowed for CHAR data.
(SQR 5528) Sybase ct_send error in cursor 119:
(138) ct_param(): user api layer: external error: A data length of
300 exceeds the maximum length allowed for CHAR data.
SQL: insert into tempdb..detail (out_line) values (@__p1)
Error on line 155:
(SQR 3734) Couldn't compile SQL.
SQRW: Program Aborting.
Am running SQR V3.0.18.1 in a Sybase 11 environment. The SQR client is
on SunOS 5.5.1 and also on WinNT. Sybase is under SunOS 5.5.1