MySQL 8

[Andrew Kirkby]

I am using FileMaker 19 on a Windows 2016 server. The database is MySQL 8 because there is functionality I need in that version.
The ODBC driver is the MySQL driver version 8.
I have been having problems with FileMaker not recognising SQL views. Everything works okay but to get FileMaker to recognise the sequel views, I have to go to the database configuration and sync the views. As soon as that is done the application works on a browser from the server and on FileMaker pro or a client.If I log off and log back on again, I have to re-sync the views.I'm not having any other problems.
Looking at the documentation FileMaker only supports MySQL 5.7.

I don't know if there are options to use on the ODBC driver or whether FileMaker need to change the code.

Is there any way around this problem please otherwise my only option is to move to another database which is going to be a lot of work.

Thanks

Andy