table name 'case' issue between PHP4 & 5
Posted: Tue Jun 06, 2006 7:40 am
I have a production server on Linux running PHP4, MySQL 4.1.19
I have a development server on Unix running PHP5, MySQL 4.1.19
I am using a piece of code called MyActiveRecord.0.2 to build objects for each of my tables.
On PHP5 it works fine, but on PHP4 i get an error trying to access the table.
I tracked it down to a 'case' issue. My table name is 'Bug'. If i change it to 'bug' then it works on PHP4.
It is not practical to change all my table names on the development system.
I changed my Unix system to PHP4 and it behaves the same, so it seems to be a PHP issue & not an OS problem.
Is there a way to make it work with table names of mixed case with PHP4?
mark
I have a development server on Unix running PHP5, MySQL 4.1.19
I am using a piece of code called MyActiveRecord.0.2 to build objects for each of my tables.
On PHP5 it works fine, but on PHP4 i get an error trying to access the table.
I tracked it down to a 'case' issue. My table name is 'Bug'. If i change it to 'bug' then it works on PHP4.
It is not practical to change all my table names on the development system.
I changed my Unix system to PHP4 and it behaves the same, so it seems to be a PHP issue & not an OS problem.
Is there a way to make it work with table names of mixed case with PHP4?
mark