469,568 Members | 1,676 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

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

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
1 2751
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.

Similar topics

reply views Thread by Philip Stoev | last post: by
reply views Thread by lowellturner | last post: by
10 posts views Thread by Mike | last post: by
4 posts views Thread by jimdscudder | last post: by
4 posts views Thread by natG | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.