The MySQL documentation [1] explains the possibility of using case sensitive table names on all plattforms (by setting lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows)...with one exception:
Exception: If you are using InnoDB tables and you are trying to avoid these data transfer problems, you should set lower_case_table_names to 1 on all platforms to force names to be converted to lowercase.
My questions are:
- Why is it recommended to use lower case table names for InnoDB?
- What can happen if you set up InnoDB tables to be case sensitive?
[1] https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
No comments:
Post a Comment