How to force adodb php library to use lowercase field names

Posted by spam on Stack Overflow See other posts from Stack Overflow or by spam
Published on 2009-06-23T21:34:57Z Indexed on 2010/04/17 22:03 UTC
Read the original article Hit count: 235

Filed under:
|
|

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.

© Stack Overflow or respective owner

Related posts about php

Related posts about adodb