Posted by Tony Marston on 06/04/07 18:06

I am from the old school where case sensitive software and operating systems
did not exist, so I was taught to use underscores as separators and not a
change in case. I therefore use lowercase for all my database/table/column
names and thus avoid problems when switching between Windows and non-Windows
platforms.

Case sensitive software sucks bigtime.

--
Tony Marston
http://www.tonymarston.net
http://www.radicore.org

<e_matthes@hotmail.com> wrote in message
news:1180298001.838907.230300@z28g2000prd.googlegroups.com...
> Hello,
>
> 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. The solution seems to be:
>
> 1 - change all table names (and other case-sensitive names) to an all-
> lowercase convention, i.e. siteStats => sitestats or site_stats;
> 2 - change table names on live version, in the database itself, to
> lowerUpper format.
>
> I really like using the lowerUpper format because I find it annoying
> to type underscores all the time, and lowerlower becomes hard to
> read. However, it is more important to me that my live and local
> scripts are identical.
>
> Does anyone else use the lowerUpper format successfully for things
> like mySql table names, when developing on windows and hosting on
> linux? Any suggestions? Thank you.
>

[Back to original message]