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

Reply via email to