Data with \x{00}'s at start into LONG BYTE (DBD::MaxDB)

[Robert Sedlacek]

Hi!

I'm wondering what's to do to insert data that starts with multiple Hex
00 into a LONG BYTE column? For testing, i have this table:

CREATE TABLE TEST1(
    ID    INTEGER NOT NULL,
    DATEN LONG BYTE,
)


and use the following perlscript:

#!/usr/bin/perl
 use warnings; use strict;

 use DBI;
 use DBD::MaxDB;
 use Data::Dumper;

 my $dta = "\x{00}\x{00}\x{00}foobar";

 my $dbh = DBI->connect( qw/dbi:MaxDB:VAVAU test test/ );
 my $sth = $dbh->prepare( qq/
         INSERT INTO Test1
                ( ID, DATEN ) VALUES ( ?, ? )
 / );

 $sth->bind_param( 1, 16 );
 $sth->bind_param( 2, $dta );
 $sth->execute();

 $sth = $dbh->prepare( 'SELECT * FROM Test1 WHERE ID = 16' );
 $sth->execute;
 print Dumper $sth->fetchrow_hashref;
__END__


And i get this output:

$VAR1 = {
          'ID' => '16',
          'TEXT' => undef,
          'DATEN' => '',
          'LANG' => undef
        };


I'd be very thankful if someone could give me a hint on this one!
Thanks for your time!


Greetings
Robert


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]