[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 :-).

-- 
Jeff


More information about the Pdx-pm-list mailing list