Delimiting Identifiers
| Database | Delimiter | Notes |
|---|---|---|
| Access 2000 | [ ] | Unable to escape [ or ] inside identifiers |
| DB2 8.1 | " | |
| Firebird 1.5 | " | |
| FrontBase 4.1 | " | Unable to escape " inside identifiers |
| MySQL 4.0 – 4.1 | ` | Unable to escape ` inside identifiers |
| Oracle 9.2 | " | Unable to escape " inside identifiers |
| PostgreSQL 7.4 | " | |
| SQL Server 2000 | [ ] | |
| SQLite 2.8 | " | |
| Sybase ASE 12.5 | " | must execute set quoted_identifier on sometime prior to use |
DON'T USE THEM!
If you're crazy enough to use them, use PEAR::DB's quoteIdentifier() method on identifiers before using them in queries.