creating case sensitive table names

[jimoblak]

I am trying to create a table called 'SoftwareBugs' but the table becomes 'softwarebugs' when the following query is run on MySQL 3.23.55-nt (Windows). Am I not allowed to use capital letters in a table name?

CREATE TABLE SoftwareBugs (
  ID smallint(5) unsigned NOT NULL auto_increment,
  Date varchar(10) default NULL,
  Category char(2) default NULL,
  Bug text NOT NULL,
  Details text,
  Version varchar(10) default NULL,
  Reporter text,
  Solution text,
  Severity char(2) default NULL,
  Rank smallint(5) unsigned default '0',
  PRIMARY KEY  (ID),
  UNIQUE KEY ID (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

 

[jimoblak]

Okay - I found help at

http://www.mysql.com/doc/en/Name_case_sensitivity.html

One way to avoid this problem is to start mysqld with -O lower_case_table_names=1. By default this option is 1 on Windows and 0 on Unix.

...But where can I set this option to '0' in Windows XP? MySQL starts as a service and I am not familiar with enabling this option. When I go to the XP computer management window>Services>MySQL, it seems that I can only apply this option when manually starting the mysql service.

 

[QatQat]

stop the service from control panel and restart it from dos prompt

c:\net start mysql -O lower_case_table_names=x


Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[JustKIDn]

I wonder if you can set this option in my.ini?


tgus

____________________________
Families can be together forever...

 

[jimoblak]

Here's what eventually worked in my.ini...

[mysqld]
set-variable = lower_case_table_names=0