Did you convert the table/column names to lower case? If
"lower_case_table_names is=1" MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you should run an ALTER query to change them to
lower-case ...
ALTER TABLE tbl_name CHANGE [COLUMN] old_col_name create_definition
(http://www.mysql.com/doc/A/L/ALTER_TABLE.html)
Gerald Jensen
----- Original Message -----
From: "Rui Rosa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 6:37 PM
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
