v5:reference:adodb_quote_fieldnames
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| v5:reference:adodb_quote_fieldnames [2021/10/25 15:49] – warning true/false cause uppercase conversion in 5.21 dregad | v5:reference:adodb_quote_fieldnames [2022/06/09 10:05] (current) – Document BRACKETS quoting (introduced in #246) dregad | ||
|---|---|---|---|
| Line 11: | 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| | ||
v5/reference/adodb_quote_fieldnames.txt · Last modified: 2022/06/09 10:05 by dregad