 | | | DB & table name case display... | DB & table name case display... 2004-12-21 - By jsWalter
Back
I have this SQL statement (see below).
It creates a table. notice the case in the name of the table.
On my Linux box, the case is unchanged.
On my PC, it is changed to lower case.
Why?
This "feature" of PC has caused me 2 days time trying to figure out why my
DB dump from home was not working on my Linux box at work.
Please explain. Please tell me how I can "fix" this.
thanks
Walter
CREATE TABLE `ControlledObject` (
`ControlledObject_id` int(10) unsigned NOT NULL auto_increment,
`ControlledObject_name` varchar(128) NOT NULL default '',
`on_what_table` varchar(128) default NULL,
`on_what_field` varchar(128) default NULL,
`user_field` varchar(32) default NULL,
`data_source_id` int(10) unsigned default NULL,
PRIMARY KEY (`ControlledObject_id`),
KEY `data_source_id` (`data_source_id`)
) TYPE=InnoDB AUTO_INCREMENT=1;
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|