v5:reference:adodb_quote_fieldnames
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous 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 [2022/06/09 10:05] (current) – Document BRACKETS quoting (introduced in #246) 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 10: | Line 11: | ||
^Value^Description^Example^ | ^Value^Description^Example^ | ||
|false|No quoting is done|SELECT field_name FROM table| | |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| | + | |true|Quoting is done((The quoting character is driver-specific and defaults to ''"'' |
+ | |BRACKETS|Fields are wrapped in brackets((The brackets type is driver-specific, | ||
|UPPER|Quoting is done, field name is upper cased (default)|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| | |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