Re: Associative arrays and case sensitivity
| From: | Tomas V.V.Cox | Date: | Tue, 11 Sep 2001 23:20:16 +0000 |
| Subject: | Re: Associative arrays and case sensitivity | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 12 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-1887@lists.php.net to get a copy of this message | ||
Chuck Hagenbuch wrote:
>
> Quoting "Tomas V.V.Cox" <cox@idecnet.com>:
>
> > I found that situation more hard to occur than the habitual change from
> > one database to other. Any way, we could use lower case columns on
> > case-sensitive databases only when the "optimize as portability" option
> > is set to don't loose performance or compatibility.
>
> Don't you mean the other way around? (i.e., always lowercasing column names
> _does_ lose performance)
>
We are talking about the same thing :-) You know, by default, the driver
acts in "performance" mode, but you can switch it in connect to
"portability" (normally slower but more portable).
$db = DB::connect($dsn, array('optimize' => 'portability'));
So, use "portability" to do the lowercasing.
Tomas V.V.Cox
PD.- Sorry if my english is not always very clear.