[Pdx-pm] (OT) SQL style question

Jeff Zucker jeff at vpservices.com
Thu Jan 13 14:42:57 PST 2005

David Wheeler wrote:

> I believe that double-quotes are the SQL-standard way of using 
> non-standard character in entity names in a database.


> So it should be portable.

Not true :-(.

For example, MySQL uses backticks (ugh) as the default delimiter for 
identifiers.  It will accept the standard double-quote character only if 
the database server was started with the ANSI_Quotes flag.  MS Access 
uses square brackets as identifier delimiters, although I think it also 
accepts double-quote.


More information about the Pdx-pm-list mailing list