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.1635169764.txt.gz · Last modified: 2021/10/25 15:49 by dregad