Posted by e_matthes on 05/29/07 14:40

On May 28, 9:16 am, Dikkie Dik <nos...@nospam.org> wrote:
> > 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.


Thanks everyone; this has helped me develop an approach that will work
well for my projects.

• Next in forum: Re: script to generate an external link
• Prev in forum: date_default_timezone_set() returns a 4-hour late time
• Thread view: Re: Naming conventions in php referring to mysql databases

[Reply to this message]