ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== $ADODB_QUOTE_FIELDNAMES ======
~~NOTOC~~
<WRAP info>
The behavior of field name quoting will change in ADOdb Version 6
</WRAP>
This global variable controls 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((The quoting character is driver-specific and defaults to ''"'')), no case handling of the field name|SELECT `field_name` FROM table|
|BRACKETS|Fields are wrapped in brackets((The brackets type is driver-specific, square brackets ''[]'' are used by default,)), 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|

<WRAP important>
While the intended behavior when using //true// or //false// is to not do any case conversion of the field names, in 5.21 they are actually **converted to upper case**.

This is a [[https://github.com/ADOdb/ADOdb/issues/745|known issue]], caused by a design problem with this setting which mixes case conversion and quoting. 
It will be fixed in a future release.
</WRAP>

===== Usage =====
<code php>
$ADODB_QUOTE_FIELDNAMES = 'NATIVE';
</code>