limit to insert image

limit to insert image

Post by Erwan Pianezz » Sat, 17 Oct 1998 04:00:00


Hi,
Is the size of the image datatype limited to 64kb ?

Thanks,
Erwan

 
 
 

limit to insert image

Post by Bret Halfor » Tue, 20 Oct 1998 04:00:00



> Hi,
> Is the size of the image datatype limited to 64kb ?

No, the image datatype can hold up to 2,147,483,647 bytes (2 GB).

There is a limit of ~120K for image data inserted interactively
using the TSQL "writetext" command.  Open Client programs can
use a different technique to write larger value.

Note that the "set textsize" command can limit the amount of
data displayed for output.
--
Bret Halford                    Imagine my disappointment
Sybase Technical Support        in learning the true nature            
3665 Discovery Drive            of rec.humor.oracle...
Boulder, CO 80303