Re: DB & table name case display... - SGr...@unimin.com - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Re: DB & table name case display...

From	Sent On	Attachments
jsWalter	20 Dec 2004 22:04
Chris	20 Dec 2004 22:40
SGr...@unimin.com	21 Dec 2004 06:08

Subject:	Re: DB & table name case display...
From:	SGr...@unimin.com (SGr...@unimin.com)
Date:	12/21/2004 06:08:23 AM
List:	com.mysql.lists.win32

Hi Walter,

The case sensitivity of the database objects (databases and tables) is dependent on the OS. Unfortunately, MS OS's are not case-sensitive. It all explained in some detail here:

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

That article goes into some settings you can use and some of the of the problems you can encounter with cross-platform case-sensitivity. Yet another reason to wonder what M$ was $moking when they designed their OS's.

Shawn Green Database Administrator Unimin Corporation - Spruce Pine

"jsWalter" <jsWa...@torres.ws> wrote on 12/21/2004 01:04:32 AM:

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

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;