ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


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:

ValueDescriptionExample
falseNo quoting is doneSELECT field_name FROM table
trueQuoting is done, no case handling of the field nameSELECT `field_name` FROM table
UPPERQuoting is done, field name is upper cased (default)SELECT `FIELD_NAME` FROM table
LOWERQuoting is done, field name is lower cased SELECT `field_name` FROM table
NATIVEQuoting is done, field name is as defined in the databaseSELECT `Field_Name` FROM table

Usage

$ADODB_QUOTE_FIELDNAMES = 'NATIVE';
v5/reference/adodb_quote_fieldnames.txt · Last modified: 2016/01/19 06:32 by 66.249.75.217