Hi,
yes it makes a huge difference,
as the tables are stored in files and therefore if
the filesystem is case-insensitive (Windows) you can
use either case in your queries, while on a case-sensitive
filesystem (linux etc) you can't.
See: http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.html
/Johan
Digvijoy Chatterjee skrev:
Hello,
I am using MySql-5.0.21 on Suse-Linux-10, i created tables using
lowercase names
for example ;
mysql> create table a (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> select * from A;
ERROR 1146 (42S02): Table 'mysql.A' doesn't exist
mysql> select * from a;
Empty set (0.01 sec)
I have upgraded from mysql-4.0.17 to 5.0.21 ,and all the ANSI-SQL
queries from my application using UPPERCASE table names are bombing, i
immediately had to stop 5.0.21 and restart mysql-4.0.17.
Is there any way to get around this problem and have a smooth upgrade.
Regards
Digz
The previous version of the App was on Windows(mysql-4.0.17) .this
ones on Linux .Does that make a difference ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
