Careful. When you do an insert for LONG datatypes, you may need to use bind_param. Otherwise data over 255 or so bytes gets cut off when inserted.

UPDATE: Some example code is below:

  my $sql = qq{ INSERT INTO Object (Key, LongData) VALUES (?, ?) };
  my $sth = $dbh->prepare( $sql ) or croak $DBI::errstr;

  $sth->bind_param(1, $key,      { TYPE=>DBI::SQL_INTEGER } );
  $sth->bind_param(2, $longdata, { TYPE=>DBI::SQL_LONGVARCHAR } );