First, thanks for your fast reply :)
Am Dienstag, den 19.07.2005, 15:06 +0200 schrieb Paskamp, Marco:
> it seems that you are trying to insert binary values into a character
> long column (long [ascii|unicode]). For binary values you should define
> your table column as long byte. The following code snippet gives an
> example on how to insert Blob/Clob values into the database using
> DBD::MaxDB.
The full problem is more that there is already a Database, which was
"upgradet" to MaxDB from Adabas. I have a write_long function used in
various big scripts which just takes the table, the field, the where-
clause and the data. The fields in the database are LONG ASCII *or* LONG
BYTE.
I have a testcase here, where I want to write text into a LONG BYTE
column, which fails with the named "Conversion from binary value to
string is not enabled" error.
> my $long_gen = "abcdefghijklmnopqrstuvwxyz";
> my $long_description = $long_gen x 2000;
Mine isn't even that long, 3 lines x about 80 chars ..
> print " Test 3: insert into table\n";
> my $sth1 = $dbh->prepare ("INSERT INTO BLOBTEST (I, L) VALUES (?, ?)");
> $rc |= $sth1->bind_param (1, 1);
> $rc |= $sth1->bind_param (2, $long_description);
> $rc |= $sth1->execute ();
Thanks, I'll try to build a simple testcase up on that.
Robert
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
