Hi I am using mysql 3.23.30 under SuSE Linux 7.1. I tried to make my table names case insensitive by setting lower_case_table_names=1 but this had no effect. Even if the variable is set and a database as well as all tables are created new in lower case a select with an upper case name for a table fails. mysql> select * from GRU; ERROR 1146: Table 'rg.GRU' doesn't exist Does anybody know why? Roland Geist mailto:[EMAIL PROTECTED] Developer http://www.openshop.com --------------------------------------------------------------------- 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