By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,636 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,636 IT Pros & Developers. It's quick & easy.

Lower case MySQL table names on Windows Server 2003....

P: n/a
Hi,

I currently administer our MySQL db version 3.23.56 on a Linux Cobalt
Qube server via an external fron-end piece of software.
My Table Names have capital letters at the beginning, i.e.
StockMovements, OrderLines.....

We are now implementing a cross-over to a Windows Server 2003 machine.
I have installed MySQL version 4.0.20a and initially it was stated as
4.0.20a-debug. I managed to find another piece of software to take it
out of debug mode as I thought this would help with the table names.
The version is now 4.0.20a-max.

If I rename the imported tables say from orderlines to OrderLines, it
stays, but if I refresh or close/re-open my fron-end, all the table
names have reverted back to lower case ?

I have lots of .asp apps which are currently working of my Linux MySQL
db using Capitals in the table names and fields. Obviously I do not
wish to start re-coding all my web pages once I move accross to
Windoes Server 2003

Please can anyone shed some light on this issue ?

Thanks

David
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In article <c1**************************@posting.google.com >,
da***@scene-double.co.uk (David) wrote:
I currently administer our MySQL db version 3.23.56 on a Linux Cobalt
Qube server via an external fron-end piece of software.
My Table Names have capital letters at the beginning, i.e.
StockMovements, OrderLines.....

We are now implementing a cross-over to a Windows Server 2003 machine.
I have installed MySQL version 4.0.20a and initially it was stated as
4.0.20a-debug. I managed to find another piece of software to take it
out of debug mode as I thought this would help with the table names.
The version is now 4.0.20a-max.

If I rename the imported tables say from orderlines to OrderLines, it
stays, but if I refresh or close/re-open my fron-end, all the table
names have reverted back to lower case ?

I have lots of .asp apps which are currently working of my Linux MySQL
db using Capitals in the table names and fields. Obviously I do not
wish to start re-coding all my web pages once I move accross to
Windoes Server 2003

Please can anyone shed some light on this issue ?


<http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html>

--
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.