Re: Associative arrays and case sensitivity

Edin Kadribasic wrote: > > I have to deal with an application that need to support both pgsql and oci8. > It was originally written for Oracle, but it is being ported to Postgres. My > problem is that Oracle always returns column names in uppercase, while > Postgres does exactly the opposite thing. > > My quick fix was to patch pgsql module to add a configuration parameter that > forces return of uppercase associative arrays. I haven't used the oci driver, but if all the backends returns columns lowercase, the logic step is to change oci8 to do the same. Perhaps we could add a "portability" options to do that? For example the phplib guys are "strlowering" column names. > I would really hate to have to go through the whole code and change all sql > statements to put double quotes around each column name (we're talking some > 50.000 lines of php code). > Why do that? Tomas V.V.Cox