18 Feb
2008
18 Feb
'08
6:18 p.m.
Totally correct. Each DB come with its specific delimited identifiers, e.g. ` (MySQL), " (PostgreSQL, Oracle, DB2, SQLite), [ ] (MSSQL). So what I am proposing in http://drupal.org/node/371 is quite simple: use an universal token, as like as the idea of { } for table prefix.
Well, I see you're already on the right track. I should have read that first ... :) One thing to keep in mind is that delimited identifiers are case sensitive per the SQL standard. That's probably not an issue, I just didn't see it brought up, and it's something to be aware of. This is something that an ORM deals with easily because it already has the concept of identifiers. -Dave