* Miguel Angel Solorzano

<snip>

> * Roger Baklund
>> mysql> rename table U1 to U2;
>> ERROR 7: Error on rename of '.\test\u1.MYI' to '.\test\u2.MYI' (Errcode:
13)
>> mysql> alter table U1 rename as U2;
>> Query OK, 0 rows affected (0.01 sec)

<snip>

> How you can see we don't have a constant behavior of the Windows OS
> in the handle of lower/upper case names.
>
> The user should know if his application will works on NT/Win2K should
> expects error messages with write operation using different syntax
> with the lower/upper case.

Thanks for the detailed reply. :)

I did my tests on a pretty old version, 3.23.30-gamma, on a win2k machine. I
was not aware of the lower_case_table_names variable. (This explains why I
got lower case filename in my error message, while Fred Lovine got upper
case filename... I was a bit puzzled about that.)

Can we from this conclude that it is safer to use all lowercase table names
when one want to make an application that should run on _any_ platform? That
way there should never be an error because of letter casing in table names,
regardless of the lower_case_table_names setting, windows version and even
mysql version (at least 3.23.6 and later)?

There is a phrase about this in the documentation:

"If you have a problem remembering the used cases for a table names, adopt a
consistent convention, such as always creating databases and tables using
lowercase names."

<URL: http://www.mysql.com/doc/N/a/Name_case_sensitivity.html >

Maybe this should be "upgraded" to an advise to use lowercase names to
assure cross platform and version compatibility?

--
Roger
query


---------------------------------------------------------------------
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

Reply via email to