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 [2016/01/19 06:32]
66.249.75.217 ↷ Links adapted because of a move operation
v5:reference:adodb_quote_fieldnames [2021/10/25 15:49] (current)
dregad warning true/false cause uppercase conversion in 5.21
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
 </WRAP> </WRAP>
-This global variable controls this quoting and casing of field names when the [[.connection:autoexecute|autoExecute()]] method is used. The default behavior of autoExecute is to quote field names, and convert them to upper case.+This global variable controls quoting and casing of field names when the [[.connection:autoexecute|autoExecute()]] method is used.  
 +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://github.com/ADOdb/ADOdb/issues/745|known issue]], caused by a design problem with this setting which mixes case conversion and quoting. 
 +It will be fixed in a future release.
 +</WRAP>
  
 ===== Usage ===== ===== Usage =====
v5/reference/adodb_quote_fieldnames.txt · Last modified: 2021/10/25 15:49 by dregad