Web Hack List

Collected research

MySQL and SQL Column Truncation Vulnerabilities

MySQL silently truncates an over-long string to the column width and, in its default non-strict mode, compares trailing spaces as equal. Registering a username padded with spaces past the limit therefore creates a second row that logs in as the original account, so an application checking for a duplicate name before insertion can still be made to collide with an existing administrator.

Record

Researcher
Stefan Esser
Published by
suspekt.org
Topic
Injection

In the archive

Tags

This page is the archive's own catalogue record. The research is the work of Stefan Esser, first published at the original source. Preserved copies are kept so the citation survives its host; this one was last captured on .