< Concatenation: Formatting Query   (Previous) Table of Contents (Next)   Delimiting Identifiers: Example >

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.