ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:adodb_assoc_case

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
v5:reference:adodb_assoc_case [2019/05/08 13:26] – Example usage: use constants instead of values, simplify code and define $ADODB_FETCH_MODE dregadv5:reference:adodb_assoc_case [2019/05/08 16:32] – [Possible values] reword dregad
Line 13: Line 13:
 |ADODB_ASSOC_CASE_UPPER|1|uppercase field names|  |ADODB_ASSOC_CASE_UPPER|1|uppercase field names| 
 |ADODB_ASSOC_CASE_NATIVE (Default)|2|native-case field names| |ADODB_ASSOC_CASE_NATIVE (Default)|2|native-case field names|
 +
 +With the default behavior, ''ADODB_ASSOC_CASE_NATIVE'', ADOdb does not perform any transformation on field names, and returns them exactly as they are defined by the DBMS. 
  
 <WRAP tip> <WRAP tip>
-The default behavior, ''ADODB_CASE_NATIVE'', lets the DBMS control the fields' casing (i.e. ADOdb returns them exactly as they are defined by the DBMS). However, when writing portable code, it is strongly recommended to choose default behavior and stick to it, as there is no consistent casing across databases and some DBMS may returned mixed-case keys.+When writing portable code, it is strongly recommended to choose either upper or lower case.  
 +Relying on the native case default will likely cause compatibility issues, as there is no consistent casing across databases and some DBMS may returned mixed-case keys.
 </WRAP> </WRAP>
  
v5/reference/adodb_assoc_case.txt · Last modified: 2022/06/08 16:14 by dregad