[Pdx-pm] (OT) SQL style question

[Jeff Zucker]

David Wheeler wrote:

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

True.

> 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.

-- 
Jeff