Quoting integers

I've been under the impression that quoting integers in SQL queries is frowned upon, but I've recently le开发者_如何学Pythonarned that prominent frameworks like Django adheres to this practice. Is it in fact perfectly acceptable?

---

The question implies that you put naked values in your SQL query in the first place. I think the most "acceptable" practice would be to parameterize the query instead - that way you don't have to concern yourself with issues such as this; let the data access library handle it for you instead.

---

Quoting integers in SQL has only a minor performance penalty. Removing the quotes is much less work than converting the ASCII representation to a binary integer.

So I'd say it's perfectly acceptable, especially for a RAD framework.

---

I'm not sure about all SQL databases, but SQL Server will implicitly convert a quoted number to an int. For example the following returns 166 in SQL Server 2000:

select '500'/3