Fwd: Table names case sensitivity
Hi all, My problem goes away after I have upgraded MySQL from 3.23.41 to 3.23.46. Thanks you for anyone who have made suggestions or who have tried to figure out the solution. Kent. --- Mr Kent Cheung <[EMAIL PROTECTED]> wrote: > Date: Wed, 30 Jan 2002 20:01:21 -0800 (PST) > From: Mr Kent Cheung <[EMAIL PROTECTED]> > Subject: Table names case sensitivity > To: MySQL Discussion <[EMAIL PROTECTED]> > > Dear MySQL community, > > I am new MySQL user. I want to migrate a M$ SQL > Server > database to MySQL in a Linux box. Since table names > in > MySQL@Linux is case sensitive, I am having troubles > connecting to the server via ODBC from a Windows > box. > > I search the documentation and find that I may be > able > to disable the case sensitivity by setting the > variable called lower_case_table_names to 1 when > starting the server. I edit my.cnf and restart the > server. Everything seems OK. mysqladmin and the Show > Variables command in mysql confirm that this > variable > is now 1 instead of 0 before I make the changes. I > have also changed the schema so that all table names > are now in lower cases. > However, when I perform a select, eg., > > SELECT * FROM Company; > > Then, an error occurs that tells me that the user > xxx > is not allowed select the table. Of course, there is > no error when the following SQL is submitted: > > SELECT * FROM company; > > I change my.cnf back and repeat the above tests and > the error persists. Thus, nothing seems to be > changed > by setting the variable. > > Have I missed anything? > > Thanks in advance. > > __ > 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 > __ 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
Fwd: Table names case sensitivity
Mr, Thursday, January 31, 2002, 12:29:24 PM, you wrote: MKC> Hi, MKC> As what I described in the original text, I have MKC> changed the table names to lower cases. Thus, I think MKC> I have done exactly what the manual says. Is this a MKC> bug or what have I missed? You have grants on database.Company instead of database.company You should update permissions for you. MKC> Thanks for your suggestion anyway. MKC> Kent. [skip] >> >> 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; >> -- 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
Fwd: Table names case sensitivity
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
