[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!



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