Hi, As what I described in the original text, I have changed the table names to lower cases. Thus, I think I have done exactly what the manual says. Is this a bug or what have I missed?
Thanks for your suggestion anyway. Kent. --- Egor Egorov <[EMAIL PROTECTED]> wrote: > Date: Thu, 31 Jan 2002 12:12:01 +0200 > To: [EMAIL PROTECTED] > From: Egor Egorov <[EMAIL PROTECTED]> > Subject: Table names case sensitivity > > Mr, > > Thursday, January 31, 2002, 6:01:21 AM, you wrote: > MKC> Dear MySQL community, > > MKC> I am new MySQL user. I want to migrate a M$ SQL > Server > MKC> database to MySQL in a Linux box. Since table > names in > MKC> MySQL@Linux is case sensitive, I am having > troubles > MKC> connecting to the server via ODBC from a > Windows box. > > MKC> I search the documentation and find that I may > be able > MKC> to disable the case sensitivity by setting the > MKC> variable called lower_case_table_names to 1 > when > MKC> starting the server. I edit my.cnf and restart > the > MKC> server. Everything seems OK. mysqladmin and the > Show > MKC> Variables command in mysql confirm that this > variable > MKC> is now 1 instead of 0 before I make the > changes. I > MKC> have also changed the schema so that all table > names > MKC> are now in lower cases. > MKC> However, when I perform a select, eg., > > MKC> SELECT * FROM Company; > > MKC> Then, an error occurs that tells me that the > user xxx > MKC> is not allowed select the table. Of course, > there is > MKC> no error when the following SQL is submitted: > > MKC> SELECT * FROM company; > > MKC> I change my.cnf back and repeat the above tests > and > MKC> the error persists. Thus, nothing seems to be > changed > MKC> by setting the variable. > > MKC> Have I missed anything? > > Yes, look in the manual: > http://www.mysql.com/doc/N/a/Name_case_sensitivity.html > If you set option lower_case_table_names=1, you > should convert your > old table names befor starting mysqld. > > > > > > -- > For technical support contracts, goto > https://order.mysql.com/ > This email is sponsored by Ensita.net > http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.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 > __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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