Hi guys,
i have had enough trouble with PEAR DB abstraction Layer.
My problem is with capitalized Column / Table names in case of Postgres SQL.
MySQL supports both small as well as upper case letters .. where as postgres expects everything in small case.
I had already posted two messages in this forum. But haven't got any satisfactory reply. I have latest versions of both PHP (4.0.6) and Postgres(7.1.3) ..(This was suppose to solve my problem!! but it dind't)
..
And i am left with no other option than re-editing 5MB of PHP source files (Converting all column names to lower) ..
What if tomorrow i want to port my Database to Oracle .. should i have to re-edit all my code again (Convert again to UPPER CASE since Oracle supports only upper case column names.)
If this is the situation .. what is the point in having a abstraction layer.
Can somebody suggest me a better(?) solution for this please !!!
Danny Appaiah.
i have had enough trouble with PEAR DB abstraction Layer.
My problem is with capitalized Column / Table names in case of Postgres SQL.
MySQL supports both small as well as upper case letters .. where as postgres expects everything in small case.
I had already posted two messages in this forum. But haven't got any satisfactory reply. I have latest versions of both PHP (4.0.6) and Postgres(7.1.3) ..(This was suppose to solve my problem!! but it dind't)
..
And i am left with no other option than re-editing 5MB of PHP source files (Converting all column names to lower) ..
What if tomorrow i want to port my Database to Oracle .. should i have to re-edit all my code again (Convert again to UPPER CASE since Oracle supports only upper case column names.)
If this is the situation .. what is the point in having a abstraction layer.
Can somebody suggest me a better(?) solution for this please !!!
Danny Appaiah.