>From my experiance, you cant,
you can use all table names lowercase,
but that will mean you will have to refer to
them in lowercase when issuing queries. unix, unlike windows,
tends to operate in a case sensitive manner on everything
-----Original Message-----
From: Rui Rosa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 12:38 AM
To: [EMAIL PROTECTED]
Subject: lower_case_table_names issue
Hi to all,
I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0
that provide a version of MySql which I'm trying to use from a VisualBasic
application (on win2000), I connect to my database on MySQL using MySqlODBC,
and everyting goes OK, except the table names wich I need to be case
insensitive on queries, after reading the manual I found that I could use
the variable 'lower_case_table_names=1' to this prupose. I set the variable,
but when I try to select something MySQL returns a error 'database.MyTable
does not exist', but she exists with name 'mytable'.
If someone could help!
Tankyou
Rui Rosa
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
