Defending Against SQL Injection by Fiat

SQL injection is an attack on computer database systems where an attacker exploits an assumption made by the programmer about the kinds of data that will be entered in the application. The assumption is that no one will use reserved characters, such as the apostrophe. However, this assumption is often false.

The Australian state of Victoria addressed the situation of Swift’s Creek in the following manner.

It is often argued that the name should be Swift’s Creek, with a possessive apostrophe, as the creek was named after Swift. In correct English usage this would be accurate; however under the Victorian Government’s Geographic Place Names Act 1998 apostrophes are omitted in all place names. This is to avoid confusion and debate on just this issue, and therefore no place names in Victoria are officially spelt with the possessive apostrophe.