RE: Repost: Lower Case Problems with Win XP Pro and 5.0.6 MySQL
mysql create table ABC (col1 varchar(10)); Query OK, 0 rows affected (0.03 sec) mysql show tables; +--+ | Tables_in_userdb | +--+ | abc | +--+ 1 row in set (0.00 sec) mysql NOTE THE FACT THAT THE TABLE IS created in LOWER case! Are you using MySQL on Windows? If so, please read this: Case-insensitive names Filenames are not case sensitive on Windows, so MySQL database and table names are also not case sensitive on Windows. The only restriction is that database and table names must be specified using the same case throughout a given statement. See Section 9.2.2, Identifier Case Sensitivity. ( http://dev.mysql.com/doc/mysql/en/windows-vs-unix.html ) Try using lower-case names to avoid facing problems when porting data from windows to *nix-systems. Regards, TomH -- PROSOFT EDV-Loesungen GmbH Co. KG http://www.proSoft.org St.-Kassians-Platz 6, D-93047 Regensburg [EMAIL PROTECTED] Geschaeftsfuehrer: Axel-Wilhelm Wegmannphone: +49 941 / 78 88 7-121 AG Regensburg HRA 6608 USt.183/68311 cellphone: +49 171 / 40 54 777 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lower Case Problems with Win XP Pro and 5.0.6 Mysql
Hi, Anyone experience this problem. I did the following: C:\perlsrcmysql -f --user=root --password= --port=3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 48 to server version: 5.0.6-beta-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database userdb; Query OK, 1 row affected (0.00 sec) mysql use userdb; Query OK, 1 row affected (0.00 sec) mysql create table ABC (col1 varchar(10)); Query OK, 0 rows affected (0.03 sec) mysql show tables; +-+ | Tables_in_sdidw | +-+ | abc | +-+ 4 rows in set (0.00 sec) mysql NOTE THE FACT THAT THE TABLE IS created in LOWER case! Any ideas as to why this is happening? Regards, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Repost: Lower Case Problems with Win XP Pro and 5.0.6 MySQL
Hi, Anyone experience this problem. I did the following: C:\perlsrcmysql -f --user=root --password= --port=3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 48 to server version: 5.0.6-beta-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database userdb; Query OK, 1 row affected (0.00 sec) mysql use userdb; Query OK, 1 row affected (0.00 sec) mysql create table ABC (col1 varchar(10)); Query OK, 0 rows affected (0.03 sec) mysql show tables; +--+ | Tables_in_userdb | +--+ | abc | +--+ 1 row in set (0.00 sec) mysql NOTE THE FACT THAT THE TABLE IS created in LOWER case! Any ideas as to why this is happening? Regards, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Case Problems...
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
Re: Case Problems...
Ah, I see. Was unaware of this new feature, and thanks for the explanation. -Nick On Thu, 2003-01-09 at 17:20, Stefan Hinz, iConnect (Berlin) wrote: 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
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