Jane ...
(This is based on our own experience, and info found in the MySQL Manual
... http://www.mysql.com/doc/N/a/Name_case_sensitivity.html). We have used
this procedure to convert dozens of databases, and found that setting the
server's variable to lower-case tables also requires converting
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 s
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