[Pdx-pm] (OT) SQL style question

Jeff Zucker 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 mailing list