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?
|
|
|
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 |
|
|
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 |
|
|
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?
|
|
|
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 |
|
|
|