On 02/02/16 07:29, Michał Ziemski wrote: > Column name expression: > - Firebird converts table/column names to upper case internally. I think > this should be explicitly stated as it's, I believe, failrly unique to > firebird
I don't believe that the SQL standard has changed any time recently. While it would be nice to be able to download copies of an international standard without digging into one's wallet, Upper case names is what the standard calls for. Along with using double quotes to wrap reserved words and case sensitive ones. Showing just how compliant Firebird is over other databases would perhaps be a worthwhile exercise. I did do a scan to see what was available on-line today, http://stackoverflow.com/questions/1714461/ansi-sql-manual makes nice reading and the suggestion that the standard postdates the databases seems a little strange when MySQL did not appear until 1995, while the first ANSI standard was published in 1986, a couple of years after Interbase appeared. Even today, the SQL1999 documents are still a preferred base, but I think SQL2011 is the current version, and I understand a printed copy makes a nice stool? Certainly not an evening read ... if you can afford a copy at something over $2000 :( -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs