Comment by mherrmann
6 years ago
Is this actually possible? Aren't strings at least surrounded by quotation marks ('NULL') while NULL isn't?
6 years ago
Is this actually possible? Aren't strings at least surrounded by quotation marks ('NULL') while NULL isn't?
It's not a database sanitization issue. The problem is that for cars that don't have a plate or the plate wasn't entered for whatever reason, in some cases people were entering "NULL" (the string). That then ended up matching his plate.
The 'NULL' string was being entered by the private company:
> Apparently, when they didn't have the right data for a vehicle, a privately operated citation processing center used the word NULL in the license plate field for many tickets.