You can control the case-sensitivity of MySQL in my.ini (or my.cnf).
If "lower_case_table_names is=1" MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you should run an ALTER query to change them to
lower-case ... ALTER TABLE tbl_name CHANGE [COLUMN] old_col_name
create_definition ... (http://www.mysql.com/doc/A/L/ALTER_TABLE.html)
Gerald Jensen
----- Original Message -----
From: "craig riley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 8:37 AM
Subject: Windows 2000 MySQL case sensitive?
> 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)
>
> There must be a simple solution to this (other than burning windows
2000:-)
>
> Help!
>
> Jane
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
