On Mon, 2 Jul 2001, craig riley wrote:
> Hi All,
> I have recently installed MySQL on my windows 2000 machine and
> everything is great except for the fact that it doesnt't seem to recognize
> upper case table / column names? This wouldn't be a problem if I was just
> developing locally because I could just name everything lowercase. The
> problem is that I have a lot of work that has been developed on a linux box
> that contains uppercase names! When I import these databases to my Windows
> 2000 machine MySQL converts all the names to lower case and hence, noneof
> the code works! (It's impractical for me to convert all the code)
Mysql column name isn't case sensitive att all. the table name is depend
on OS, so
windows 200 is not case sensisitve. YOu should chek your code. relying on
table name case is not recommended.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
