RE: lower_case_table_names issue
From my experiance, you cant, you can use all table names lowercase, but that will mean you will have to refer to them in lowercase when issuing queries. unix, unlike windows, tends to operate in a case sensitive manner on everything -Original Message- From: Rui Rosa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 12:38 AM To: [EMAIL PROTECTED] Subject: lower_case_table_names issue Hi to all, I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0 that provide a version of MySql which I'm trying to use from a VisualBasic application (on win2000), I connect to my database on MySQL using MySqlODBC, and everyting goes OK, except the table names wich I need to be case insensitive on queries, after reading the manual I found that I could use the variable 'lower_case_table_names=1' to this prupose. I set the variable, but when I try to select something MySQL returns a error 'database.MyTable does not exist', but she exists with name 'mytable'. If someone could help! Tankyou Rui Rosa - 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
lower_case_table_names issue
Hi to all, I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0 that provide a version of MySql which I'm trying to use from a VisualBasic application (on win2000), I connect to my database on MySQL using MySqlODBC, and everyting goes OK, except the table names wich I need to be case insensitive on queries, after reading the manual I found that I could use the variable 'lower_case_table_names=1' to this prupose. I set the variable, but when I try to select something MySQL returns a error 'database.MyTable does not exist', but she exists with name 'mytable'. If someone could help! Tankyou Rui Rosa - 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: lower_case_table_names issue
Did you convert the table/column names to lower case? If lower_case_table_names is=1 MySQL will convert all table names to lower case on storage and lookup ... but you need to first convert your old table names to lower case before starting mysqld. If you have not done so, you should run an ALTER query to change them to lower-case ... ALTER TABLE tbl_name CHANGE [COLUMN] old_col_name create_definition (http://www.mysql.com/doc/A/L/ALTER_TABLE.html) Gerald Jensen - Original Message - From: Rui Rosa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 6:37 PM Subject: lower_case_table_names issue Hi to all, I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0 that provide a version of MySql which I'm trying to use from a VisualBasic application (on win2000), I connect to my database on MySQL using MySqlODBC, and everyting goes OK, except the table names wich I need to be case insensitive on queries, after reading the manual I found that I could use the variable 'lower_case_table_names=1' to this prupose. I set the variable, but when I try to select something MySQL returns a error 'database.MyTable does not exist', but she exists with name 'mytable'. If someone could help! Tankyou Rui Rosa - 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