[Pdx-pm] (OT) SQL style question
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
More information about the Pdx-pm-list