Re: DBI case-insensitive placeholders

[dbwiz]

It is not a DBI issue. It's MySQL that has case insensitive matching.

However, you can force an exact match using the "BINARY" keyword.

There is no need to change the column definition, if what you need is just a case sensitive match.

my $sth = $dbh->prepare("SELECT * FROM data WHERE content = BINARY ? "
+);
$sth->execute("Perl");
# This will find "Perl", not "PERL" or "perl"