Hans Maurer <[EMAIL PROTECTED]> wrote: >>Description: > We're running our current TTS application with MySQL (on Unix). All database, > table and column names are in lower-case. However, we need to access this > database with a new application which (for some reason) converts all > table and column names in its SELECT statements to uppercase. > > Since MySQL is case-sensitive on Unix, I added the statement > set-variable = lower_case_table_names=1 > to /etc/my.cnf. However, statements like > SELECT COLUMN FROM TABLE; > still fail with error 1146, while > SELECT COLUMN FROM table > works. It seems that lower_case_table_names is not utilized in SELECT > (and probably other) statements.
Worked fine for me. >>Release: mysql-3.23.32 (Source distribution) 3.23.32 is an outdated version. Upgrade MySQL server to the last version (3.23.57). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
