CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> General/Other

 Table Capitalization

Print topic Send  topic

Author Message
code2go

Posts: 13
Posted: 09/27/2006, 11:01 AM

My production server is a linux box with a mysql database. The tables within the database were named with mixed case. When I ftped the files to my test server, a windows machine, the files retain their mixed case names, but when I try to add them with CCS Studio they are all lower case. Any Ideas how I can tell CCS to look at the case?

View profile  Send private message
matheus

Posts: 386
Posted: 09/27/2006, 12:31 PM

Use lowercase table name... is better.
_________________
Matheus Trevizan

Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br
View profile  Send private message
peterr


Posts: 5971
Posted: 09/27/2006, 11:21 PM

I would check with the support because this looks little strange.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
Joachim Uersfeld
Posted: 09/29/2006, 11:09 AM

Filesnames must be lowercase in Linux / Unix systems. Each mysql table
is a single file - the tablename ist the filename -> the table must be
named lower case.

Give all tables lower case names. Otherwise your project will not run
under Linux (Error: table not found). MySQL on Windows works with
lower, upper and mixed cases.

Joachim

code2go wrote:

> My production server is a linux box with a mysql database. The
> tables within the database were named with mixed case. When I ftped
> the files to my test server, a windows machine, the files retain
> their mixed case names, but when I try to add them with CCS Studio
> they are all lower case. Any Ideas how I can tell CCS to look at the
> case?
code2go

Posts: 13
Posted: 10/02/2006, 8:02 AM

Naming the tables with all lowercase is good advice, except that I have inherited this application, and the developer before me chose to use mixed case. If I rename the tables on the linux box, I will have to search/replace all the existing code. This creates too much "custom" code.

Any ideas about a setting in mysql to force the use of mixed case in Windows?
View profile  Send private message
peterr


Posts: 5971
Posted: 10/02/2006, 11:29 AM

Assuming that you will use your new application only on Windows, possibly case sensitivity is not a problem. An SQL statement like "SELECT * FROM my_table" may work with "My_Table" on Windows.
If you want to use your application on both Windows and Linux then you can try the "lower_case_table_names" option described at http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html

Also, the above document states that the process of copying MySQL tables from Linux to Windows would convert the tables to lower case. Thus possibly in CCS you could try connecting to your remote MySQL database installed on Linux, rather then copying the database to Windows.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.