Michael, wouldn't there be a way to insert more than the default. Like the
old DBD::Oracle with OCI7 where blob_read needed to be used to fetch more
than 65535 (or something like that) bytes, or is there no support in
DBD::Sybase to do that at this time. I've never used DBD::Sybase, so not
sure if there is a property that needs to be set to override the default or
not.
Ilya Sterin
-----Original Message-----
From: Michael Peppler
To: Sterin, Ilya
Cc: 'Peter Gibbons '; '[EMAIL PROTECTED] '
Sent: 06/04/2001 8:33 AM
Subject: RE: dbi variable size
Sterin, Ilya writes:
> The limit is set by the underlying database field size, and not the
driver.
> See the documentation for you database and it's data types.
In general this is correct, though there may be situations with BLOBs
(eg TEXT/IMAGE datatypes for Sybase and MS-SQL) where the default size
is limited by the driver (or the Client API). For example Sybase
limits TEXT/IMAGE to 32k by default, MS-SQL limits it to 4k by default
IIRC.
Michael
> -----Original Message-----
> From: Peter Gibbons
> To: [EMAIL PROTECTED]
> Sent: 06/04/2001 8:10 AM
> Subject: dbi variable size
>
> hi, quick questio:
>
> is there a limit on the size of a variable that you can write to a
> database
> via dbi?
>
> regards
> peter
--
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]
