v5:reference:adodb_quote_fieldnames
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
reference:adodb_quote_fieldnames [2015/07/13 01:12] – created mnewnham | v5:reference:adodb_quote_fieldnames [2021/10/25 15:49] – warning true/false cause uppercase conversion in 5.21 dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== $ADODB_QUOTE_FIELDNAMES ====== | ====== $ADODB_QUOTE_FIELDNAMES ====== | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
- | This global variable controls | + | <WRAP info> |
+ | The behavior of field name quoting will change in ADOdb Version 6 | ||
+ | </ | ||
+ | This global variable controls quoting and casing of field names when the [[.connection: | ||
+ | The default behavior of autoExecute is to quote field names, and convert them to upper case. | ||
The following behaviors are available: | The following behaviors are available: | ||
Line 11: | Line 15: | ||
|LOWER|Quoting is done, field name is lower cased |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| | |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:// | ||
+ | It will be fixed in a future release. | ||
+ | </ | ||
===== Usage ===== | ===== Usage ===== |
v5/reference/adodb_quote_fieldnames.txt · Last modified: 2022/06/09 10:05 by dregad