| Subject: | CHAR bind differences |
The following queries are different:
CREATE TABLE tester (NODE CHAR(5 BYTE));
INSERT INTO tester (node) values ('abcd');
------------------------------------------------
use DBI;
use Data::Dumper;
my $dbh = DBI->connect("dbi:Oracle:", 'who', 'cares');
my $aref;
my $aref = $dbh->selectall_arrayref("SELECT * FROM tester WHERE node =
?", undef, 'abcd');
print Dumper($aref);
my $aref = $dbh->selectall_arrayref("SELECT * FROM tester WHERE node =
'abcd'");
print Dumper($aref);
$dbh->disconnect();
------------------------------------------------
$VAR1 = [];
$VAR1 = [
[
'abcd '
]
];