transfer interbase to mysql? upper case field names

[searain]

I need to transfer InterBase to MySQL.

I didn't use advanced features in InterBase. So I think the transfer will be straight forward.

The only problem is that ibase_fetch_object,

$result->FULL_NAME;

the field name is upper case.

All I have to do is using UPPER CASE field name to create MySQL new database.

So when I call mysql_fetch_object

I can still use the upper case field name

$result->FULL_NAME;

In brief words, to transfer from InterBase to MySQL I can mass replace the "ibase_query" with "mysql_query", and "ibase_fetch_object" with "mysql_fetch_object". Most of the codes will be fine.

I don't have to change the "$result->FULL_NAME" to "$result->full_name" If I use the upper case field names in MySQL.

[tsinka]

Hi,

where exactly is the problem ? Do you have problems creating tables with upper case field names ? Which OS does the database run on ?
Thomas

[searain]

No, I didn't make myself clear here. I was checking out the way to transfer Interbase php codes to mysql php codes.

I mean if I use upper case as field name in creating the MySQL tables, I will have no trouble technically to transfer my site from InterBase codes to MySQL codes, right?

All I have to do is using mass replace to replace ibase_query to mysql_query, and to replace ibase_fetch_object to mysql_fetch_object, right?

By the way, I rarely use Interbase Only sql statements. I just have to find out these statements, and change it to general sql statements (or mysql statements), then I will be fine, right?