Hi, using your example program I was able to reproduce the error. It is a bug in DBD::MaxDB that for binary columns always the hosttype SQLDBC_HOSTTYPE_ASCII will be used instead of SQLDBC_HOSTTYPE_BINARY. I've fix this and an updated module is available soon at: http://backpan.perl.org/authors/id/M/MA/MAXDB/DBD-MaxDB-7.5.00.31a.tar.g z
regards, Marco ----------------- Marco Paskamp MaxDB, SAP Berlin > -----Original Message----- > From: Jens-Peter C. Hillers [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 21. Juli 2005 01:54 > To: maxdb@lists.mysql.com > Subject: inserting binarys with DBI::MaxDB > > Hello, > > we have problems inserting Blobs into MaxDB > > The Table: > > CREATE TABLE TEST1( > ID INTEGER NOT NULL, > DATEN LONG BYTE, > TEXT LONG ASCII > ) > > The Program: > --------------------------------- > #!/usr/bin/perl > use warnings; use strict; > > use DBI; > use DBD::MaxDB; > > my $dbh = DBI->connect( qw/dbi:MaxDB:TEST test test/ ); > > my $sth = $dbh->prepare( qq/ > INSERT INTO Test1 > ( ID, DATEN, TEXT ) VALUES ( ?, ?, NULL ) > / ); > > $sth->bind_param( 1, 13 ); > $sth->bind_param( 2, 'Test-Data' ); > > $sth->execute(); > ------------------------------------- > The Problem : > DBD::MaxDB::st execute failed: Conversion from binary value > to string is > not enabled for parameter/column (2) at ./2.blobtest.pl line 17. > > Inserting in the TEXT Column is no problem. > > MaxDB Version 7.5 > > regards > jph > ---------------------------------------------- > Jens-Peter C. Hillers > Remote Web Services GmbH > [EMAIL PROTECTED] > ----------------------------------------------- > > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
