> I'm having trouble with what appears to be a case sensitivity issue.
> Essentially, when I use the "right" case for a table name, the query fails,
> but when I use the wrong case, the query succeeds.
Well, it seems to depend on the system you are using. I noticed
that when I created tables through phpMyAdmin on my local Win
system, that the table(=file) was created on disk lower case only.
It doesn't matter on Win, as the file system is not case
sensitive, but it does on Linux. So you have to be careful if you
transfer tables.
I didn't see the create table syntax make any mistakes, so I
think it is phpMyAdmin, but I don't know - I didn't care to
check.
Check the tablename(=filename) and rename the table or change the
name in your scripts.
--
Herzlich
Werner Stürenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
