--- trunk/index_DBI_cache.pm 2004/02/05 10:56:55 219 +++ trunk/index_DBI_cache.pm 2004/02/11 08:33:51 226 @@ -51,6 +51,13 @@ $self->bench("connected to $dbd as $user"); + # force SQLite to support binary 0 in data (which shouldn't + # happend, but it did to me) + eval { + no warnings 'all'; + $self->{dbh}->{sqlite_handle_binary_nulls} = 1; + }; + return $self; } @@ -66,7 +73,7 @@ # FIX: this is not a good way to check if table exists! if ($sth->execute() && $sth->fetchrow_hashref) { my $sql = "drop table $field"; - my $sth = $self->{dbh}->do($sql) || die "SQL: $sql ".$self->{dbh}->errstr(); + my $sth = $self->{dbh}->do($sql) || warn "SQL: $sql - ".$sth->errstr(); } $sql = "create table $field ( item varchar(255),