ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:adodb_quote_fieldnames

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
v5:reference:adodb_quote_fieldnames [2021/10/25 15:49]
dregad warning true/false cause uppercase conversion in 5.21
v5:reference:adodb_quote_fieldnames [2022/06/09 10:05] (current)
dregad Document BRACKETS quoting (introduced in #246)
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 ''"'')), no case handling of the field name|SELECT `field_name` FROM table| 
 +|BRACKETS|Fields are wrapped in brackets((The brackets type is driver-specific, square brackets ''[]'' are used by default,)), no case handling of the field name|SELECT [field_name] FROM table|
 |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