News for hackers. Stuff that matters.
Re:A Big Case of Oops by smackjer on Friday February 26, 2010 @11:13AM (#1153389)
Re:A Big Case of Oops by tptacek on Friday February 26, 2010 @01:26PM (#1153743)
Escaping will get you killed. Do you know what %u2032 means? +ACc-? %ef%bd%b1? Parameterize the query.
Re:A Big Case of Oops by brlewis on Friday February 26, 2010 @02:09PM (#1153858)
Ignoring the part about PHP not knowing the difference between a byte and a character...%2032? There are databases where something other than ASCII single quote will terminate a string?
Re:A Big Case of Oops by tptacek on Friday February 26, 2010 @02:27PM (#1153906)
Sure. It depends on the database, the way the query is constructed, and the way the handle is initialized. But the bigger problem is what the web stack does to the query before it hits the database.

People have been playing charset games to get past SQL quoting for almost 10 years now, and not just in PHP.