Posted by Dikkie Dik on 05/28/07 17:16

> I am developing on a windows machine, and hosting on a linux server.
> I have written my php code using table names like siteStats and column
> names like userStatus. I have just realized the conflict this creates
> when uploading to the live server; table siteStats is not recognized,
> but table sitestats is recognized.

There is a server setting in MySQL that says how it treats table names
(add it to my.cnf if it does not exist). For linux, this defaults to "0"
(case sensitive), and for windows it erroneously defaults to "1"
(case-insensitive, stored as lower case). For your windows server, you
should set it to "2" (case-insensitive, stored as is). Even then, some
MySQL versions do not interpret this setting right (I have a 5.0x
version that gives a lower-case table name in the foreign key clauses of
a SHOW CREATE TABLE answer).

Hope this helps.

• Next in forum: Re: how to not write password in code for using to mysql?
• Prev in forum: Re: Why does include file text need to be bracketed by <?php> ... <?>
• Thread view: Re: Naming conventions in php referring to mysql databases

[Reply to this message]