<braindump>
$handle->{NoNULL} = 1; # Disable NULL values
to be implemented in DBI (though implementation in DBD would be easy too)
if NoNULL is defined, change numerics passed as undef (representing NULL) as 0,
and (var)char to ""
Possibly to be extended for different types:
$dbh->{NullTypes} = { # Replace NULL with ...
Char => " ", # single space
Number => -1, # value -1
Date => undef, # NULL
:
};
</braindump>
--
H.Merijn Brand Amsterdam Perl Mongers (http://www.amsterdam.pm.org/)
using perl-5.6.1, 5.7.1 & 626 on HP-UX 10.20 & 11.00, AIX 4.2, AIX 4.3,
WinNT 4, Win2K pro & WinCE 2.11 often with Tk800.022 &/| DBD-Unify
ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/H/HM/HMBRAND/
