Re: DBI case-insensitive placeholders

I don't think the problem is in your code, but in your database schema. You're probably searching on a column that doesn't keep case. In MySQL, CHAR columns need to be delcared BINARY to be case-sensitive.

----
I wanted to explore how Perl's closures can be manipulated, and ended up creating an object system by accident.
-- Schemer

:(){ :|:&};:

Note: All code is untested, unless otherwise stated

Comment on Re: DBI case-insensitive placeholders Select or Download Code

Replies are listed 'Best First'.
Re: Re: DBI case-insensitive placeholders by Anonymous Monk on Oct 27, 2003 at 14:41 UTC
Hmm... I'll try to change the column type -- it is currently set to VARCHAR(40). I have never had this problem with PHP code though -- it always worked case-sensitively (Of course, I was building queries by hand: `SELECT * FROM data WHERE content='$content'`)	[reply] [d/l]