In mysql I want to set lower_case_table_names=1 on existing databases to avoid cases-sensitivity issues accross multiple platforms.
What are the risks ?( besides show table issue)
B) After setting lower_case_table_names=1, will I be in position to query databases across
multiple platforms consistantly ?
select * from USERS == select * from users;
C) How the triggers + stored procedure + functions + views + events
will be affected in this regards. I know lower_case_table_names is only for "TABLE"
names but how about triggers other database objects . Will they remain case-insensitive How about views ?
D) Do I need to rename all tables before/after this configuration setting or this will do the miracle in one step (i.e lower_case_table_names=1 neutralize table names) ?
E) What will be the exact steps WRT:
mysqd / my.ini ?
lower_case_table_namesalone. The default setting gives the least problems, as it is design to work OK on both Windows and Linux.