xp-framework/rfc — Issue #163: Respect ANSI SQL in rdbms package
Author: kiesel
Created: 2011-10-17 16:01:59+00:00
State: closed
Labels: framework, implemented

Scope of Change
====
All rdbms drivers will be made more ANSI SQL compatible by preferring
single quotes as string delimiter over double quotes.

Rationale
====
Some databases can be configured to explicitely support ANSI mode
where double quotes are an indicator for quoted identifiers rather
than strings.
Thus, changing to use ANSI SQL will increase compatibility of the
XP framework's rdbms API to as many systems as possible.

Functionality
====
Change to the rdbms systems's respective SQL dialect class.

Security considerations
====
String escaping needs to be adjusted appropriately to still effectively
suppress SQL injection.

Speed impact
====
n/a

Dependencies
====

Related documents
====
- http://dev.mysql.com/doc/refman/5.1/en/ansi-mode.html
Running MySQL in ANSI mode

- http://xp-framework.net/rfc/contrib/rfc0163.diff
Implementing patch