Moestl, Tuesday, October 08, 2002, 3:47:41 PM, you wrote: MW> That's maybe true, I'll check it. As it's the default setting on Windows and I've never changed it I guess it's on.
MW> If the flag lower_case_table_names is turned on, I would expect that SHOW DATABASES os SHOW TABLES is returning lowercase-only names as well? If you create them after setting lower_case_table_names=1 - Yes. MW> I do get back the exact database and table names as the files in the DATA directory are named, including full upper/lowercases, thus I do get back the name as originally specified when creating MW> the database / table. Sorry, it's not clear enough for me what are you trying to do.. MW> The manual says (including LOOKUP queries): MW> 8<======================================= MW> If lower_case_table_names is 1 MySQL will convert all table names to lowercase on storage and lookup. (From version 4.0.2, this option also applies to database names.) MW> =======================================>8 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
