[DB-SIG] Quoting table and column names
Ryan Weisenberger
ryanw@inktomi.com
Wed, 19 Jun 2002 14:18:14 -0700
Is it safe to ALWAYS quote table names and column names in SQL
statements? My python app queries against several different kinds of
databases, most notably Oracle 8 and 9, MS SQL Server 2000, and
Sybase. When table and column names contain spaces or characters (':' or
'-'), I surround them with double quotes. So is it safe to always do
this? I thought at one time I discovered that some dbs don't like this.
Thanks,
Ryan
_________________________
Ryan Weisenberger
Software Developer
ryanw@inktomi.com
(650) 653-4595
_________________________