How to force adodb php library to use lowercase field names
- by spam
I'm trying to use adodb for db access in my webapp.
However my hosting provider has mysql case sensitive,
and I have all my fields in lowercase. But when I call getInsertSQL function,
I got them in uppercase.
Is there a way to force adodb to use lowercase?
I tried with
define('ADODB_ASSOC_CASE', 0);
$ADODB_ASSOC_CASE = 0;
But it seems to be ignored as the constant is suppose to be used only with oracle, MSSQL and other DBMS
$conn = &ADONewConnection($this->DbType);
$conn = PConnect($dbServer,$dbUser, $dbPassword,$database);
$tableName = "sample";
$insertSQL = $conn->GetInsertSQL($tableName,$objDB);
And I got the SQL statement with the column names in uppercase.
