* 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
