PhpMyAdmin question

I use phpmyadmin locally and on my website. There is a difference I can't correct. In the online database I have tables that use both upper and lower case letters while the local version always reverts to all lower case letters. I'm using version 2.2.6. What do I need to do to get both upper and lower case letters on table names for my localhost version?

Thanks for any help.

I would think you could do a dump of the database, rename the tables in the dump, drop the relevant tables, and reload them using the corrected dump file.

I've tried that a few times. The local version always forces the table to be renamed. So if I want to call a table Articles it always reverts to articles - even after doing a statement to rename it.

Is this a default setting in downloaded versions of PHP or has anyone else experienced this?

Are you running it on a Windows box? If I remember correctly, Windows automatically converts to lowercase characters... Linux uses the exact case you specify...

Can anyone confirm this... I don't want to give you the wrong information, but I'm pretty sure that's the reason for it.

Yes, I am using Windows. If that is the problem is there a way to fix it?

I don't think it's something you can fix... Like I said, Windows doesn't care about case-sensitivity...

Is your application non-functional because of this?

No, I can still do my work. I need to take the sql dump and run it through Wordpad or something so i can replace the characters that need replacing. It's just an extra step I'd like to do without but can live with.