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]
