At 17:59 16/02/2002 +0100, Roger Baklund wrote: Hi, >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?
In my personal opinion yes, not only this but to use short description names and avoiding blank spaces. However I know that the developer sometimes doesn't have option. >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? Yes. Regards, Miguel >-- >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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- 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