I am facing a problem with upper / lower case view names. Originally the views are created with upper case names. After changing something in views query the view name changes to lower case. My application runs on centos and is case sensitive.
Regardles of how the corresponding Maria Variables are set to, a tool like HeidiSQL should never change something by its own.
My setting:
Variable_name;Value lower_case_file_system;ON lower_case_table_names;2
Cheers, Klaus