Never tried myself, but other people had successes with it. Didn't know
about the problem, but I would think that ODBC takes care of that.
There were quite a few posts here before regarding the image data types in
SQLServer, but never a problem like this (as I remember).
Ilya Sterin
-----Original Message-----
From: Michael Peppler
To: Sterin, Ilya
Cc: 'Garrison G. Lutz '; '[EMAIL PROTECTED] '
Sent: 04/27/2001 8:51 AM
Subject: RE: Image databases
Sterin, Ilya writes:
> You would retrieve as any other Long/Blob data type. Set you
LongReadLen
> and LongTruncOk and fetch it. To insert you must use placeholders.
See
> docs for all of the above.
Ilya - are you sure that placeholders work with the IMAGE datatype for
MS-SQL and DBD::ODBC?
AFAIK there is a problem with passing IMAGE or TEXT datatypes as
placeholders when using the TDS protocol (which is what MS-SQL uses),
but maybe that has changed with MS-SQL 2000.
(or maybe the ODBC driver handles this internally?)
Michael
--
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]
