Nick, > CREATE DATABASE LookAtMe; > the database is created but as: > lookatme
This is not a bug, but a feature. By default, MySQL 4.0.x has lower_case_table_names set to 1. If you want to change this behaviour, put this in the [mysqld] section of your c:\my.cnf or c:\winnt\my.ini file, and restart the MySQL server: set-variable = lower_case_table_names=0 Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Nick Stuart" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 7:52 PM Subject: Case Problems... > I seem to have found a bug with 4.0.7. I just want to make sure the > issue hasn't been covered before I submit a report. > I have 4.0.7 installed on windows 2000 server with all the service packs > and stuff. When I connect to the database through a Linux client > (haven't tried it on the box itself) and issue: > CREATE DATABASE LookAtMe; > the database is created but as: > lookatme > with no caps. > Anybody run into this before? I know Winblow$ isn't case sensitive and > all but it should still create the database/folder as I type it. > -- > > -Nick Stuart > > USM Computer Science Major > Visit us at http://csforum.newtsplace.com > (run with LAMP) > > Filter Fodder: mysql, sql, queries, why isn't CREATE or DATABASE in the > god damn list! =D > > --------------------------------------------------------------------- > 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