====== ADOConnectionDefinitions::quoteFieldNames ======
~~NOTOC~~
== Data Type ==
STRING
== Default Value ==
UPPER
This global variable controls this quoting and casing of field names when the [[.connection:autoexecute|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';