First set of patches to assist RDBMS portability as previously discussed on the general development list. This covers the following:

• Identifier quoting of SQL reserved words:
  • LANGUAGE
  • MODULE
  • OPTION
  • TIME
• Identifier quoting of Virtuoso reserved word:
  • PASSWORD
• Quoting of string literals in some places
• Correct use of non-standard != logic comparison operator to <>
• Casting of some long types used in SQL functions that may not support long types

These changes are organised by front/admin then by component/module/plugin but squashed into single commits with respect to the categories of changes listed above. Given that none of the categories of changes are intended to alter any functional features, I hope that this is suitably divided and correct granularity for manual testing.

If preferred the commits are available unsquashed on separate branches under wdaniels/joomla-cms as indicated by the [branch-name] prefixes of the squashed commits messages where merged into this (sql92) branch.

These patches are relatively trivial and I do not believe to be contentious. Further patch sets I intend to raise for discussion on joomla platform/cms lists as appropriate.