Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: DBI case-insensitive placeholders

by dbwiz (Curate)
on Oct 27, 2003 at 14:41 UTC ( [id://302399]=note: print w/replies, xml ) Need Help??


in reply to DBI case-insensitive placeholders

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"

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://302399]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (5)
As of 2024-03-28 11:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found