Sterin, Ilya writes:
> 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.
Yes, there is a way of course, by setting LongReadLen, or by executing
a "SET TEXTSIZE xxxxxx" SQL command.
What I meant is that you will get truncated inserts if you are not
aware of these default size limits.
Michael
> -----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]
--
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]
