- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:reference:adodb_quote_fieldnames

# $ADODB_QUOTE_FIELDNAMES

The behavior of field name quoting will change in ADOdb Version 6

This global variable controls this quoting and casing of field names when the autoExecute() method is used. The default behavior of autoExecute is to quote field names, and convert them to upper case.

The following behaviors are available:

Value | Description | Example
--- | --- | ---
false | No quoting is done | SELECT field_name FROM table
true | Quoting is done, no case handling of the field name | SELECT `field_name` FROM table
UPPER | Quoting is done, field name is upper cased (default) | SELECT `FIELD_NAME` FROM table
LOWER | Quoting is done, field name is lower cased | SELECT `field_name` FROM table
NATIVE | Quoting is done, field name is as defined in the database | SELECT `Field_Name` FROM table

## Usage

    $ADODB_QUOTE_FIELDNAMES = 'NATIVE';

v5/reference/adodb_quote_fieldnames.txt · Last modified: 2016/01/18 21:32 by 66.249.75.217

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top