v5:reference:adodb_quote_fieldnames
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
v5:reference:adodb_quote_fieldnames [2016/01/13 02:30] – ↷ Page moved from reference:adodb_quote_fieldnames to v5:reference:adodb_quote_fieldnames mnewnham | v5:reference:adodb_quote_fieldnames [2021/10/25 15:49] – warning true/false cause uppercase conversion in 5.21 dregad | ||
---|---|---|---|
Line 4: | Line 4: | ||
The behavior of field name quoting will change in ADOdb Version 6 | The behavior of field name quoting will change in ADOdb Version 6 | ||
</ | </ | ||
- | This global variable controls | + | 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 14: | 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