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 revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
v5:reference:adodb_quote_fieldnames [2016/01/13 02:30] – ↷ Page moved from reference:adodb_quote_fieldnames to v5:reference:adodb_quote_fieldnames mnewnhamv5:reference:adodb_quote_fieldnames [2021/10/25 15:49] – warning true/false cause uppercase conversion in 5.21 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
 </WRAP> </WRAP>
-This global variable controls this quoting and casing of field names when the [[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: 2022/06/09 10:05 by dregad