ADOConnectionDefinitions::quoteFieldNames

Data Type

STRING

Default Value

UPPER

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

$acd = new ADOdb\database\drivers\mysqli\ADOConnection
$acd->quoteFieldNames = 'NATIVE';