PostGres and MySQL compatibilty!!

dannymm

Hi guys,
I am having serious problem with porting a mysql based application to Postgres.

How do i enable PostGres to read capitalized column names ?

e.g:
Table Name: NetworkTab
This table has two fields named "NetCode" and "NetworkName".

but after fetching * from NetworkTable the values fetched (associative) does not display the results.

i,e if i say
echo $Row["NetCode"] it prints nothing ... where as
echo $Row["netcode"] prints the actual correct value.. where as "NetCode" is the actual column name.
At this stage i cannot modify all the colums names to lower cases, and I am using PEAR DB.

Is there any solution to this problem.

I need a urgent solution,

Thanks in advance,
Danny ..

amcgrath

Danny, sorry I really don't know what to tell ya, I ran into the same problem the other day (Access to Postgres). I'd like to know though what your end solution is.

Anon

I'm not sure about in fetching associative arrays, but i do know that in my queries i had ot quote the capitalized words or it would be read as lowercase like so:

SELECT \"NetworkID\",somehting_lower,\"SomeThingUpper\" FROM...........

like that

so maybe in your code try

$row[\"FieldName\"]

might work I don't have time to go try right now hehe

but I recommend using all lowercase field names, it just looks better in my opinion

Keith

smarlowe

A few points need to be clarified here:

Postgresql does everything in lower case whether you like it or not.

create table Buddies (Name text, Number text, Address text, ID serial);

will create a table called buddies with fields named name, number, address, and id.

Older versions of PHP has some issues with this automatic upper to lower conversion. 4.0.6 seems to have worked around it.

In PHP 4.0.6 and postgresql 7.1.x, you can sling around table and field names with mixed upper and lower case and it just doesn't matter. In some earlier versions, you get errors.

So the simple answer is to just upgrade to the latest version of each if you can.

dannymm

I have installed both 4.0.6 and pgsql 7.1.3 ... still PHP returns everything in small case ....

I am really tired of this compatibility issues ... just now i have heard that ORACLE expects everything in UPPER CASE letters .. if this is the case .. what is the use of a Abstraction Layer ...
Even if u make ur application compatabile with MySQL/PgSQL .. it won't work with Oracle ...
Please do suggest me some other alternatives .. or else i will have to re-edit 5 MB of PHP source files .....

Thanks ..
Danny ....