[Pdx-pm] (OT) SQL style question
jeff at vpservices.com
Thu Jan 13 15:20:13 PST 2005
David Wheeler wrote:
> On Jan 13, 2005, at 2:42 PM, Jeff Zucker wrote:
>>> 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.
> Yet another reason not to use MySQL.
True, but "portable" does not mean "portable to all reasonable systems",
otherwise, there would be no need for things like ActivePerl :-).
More information about the Pdx-pm-list